Generate a 16 digit Random Number

declare @random varchar(50)
set @random = newid()
print (@random)
select substring(@random,1, 16)

Comments

  1. UnknownMarch 20, 2014 at 12:54 AM

    I want only digits, This script is returning characters too

    ReplyDelete

Post a Comment