SQL uniqueidentifier
create Proc RandomChar
as
begin
declare @val as bigint
declare @ans as nvarchar(7)
Set @val =(Select CAST(CAST(NEWID() AS VARBINARY(5)) AS bigint))
set @ans = (select substring(cast(@val as nvarchar(12)),1,3)+'-'+substring(cast(@val as nvarchar(12)),4,7))
Select @ans
end
exec RandomChar
Author:
Aamir Hasan औथोर:
आमिर हसन أثر
أمير حسن .
886fb0c4-9444-48b2-b698-e38a4d751818|0|.0
ALL, SQL 2005 & 2008
sql