利用NewID()生成随机数
摘要：CREATEFUNCTION[dbo].[RandInt](@GuidValueasuniqueidentifier)RETURNSintASBEGINdeclare@strasvarchar(10)set@str=left(@GuidValue,8)declare@iasintdeclare@numberasintset@i=0set@number=0while(@i<8)beginset@number=@number+(Ascii((substring(@str,@i+1,1)))*Power(10,@i))set@i=@i+1endreturn@numberEND
阅读全文
posted @
2011-09-16 17:01
三聪
阅读(414)
推荐(0) 编辑
