CREATE FUNCTION [dbo].[RandInt](
@GuidValue as uniqueidentifier
)
RETURNS int
AS
BEGIN
declare @str as varchar(10)
set @str=left(@GuidValue,8)
declare @i as int
declare @number as int
set @i=0
set @number=0
while(@i<8)
begin
set @number=@number + (Ascii((substring(@str,@i+1,1)))*Power(10,@i))
set @i=@i+1
end
return @number
END
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。