How to get numeric random uniqueid in SQL Server -


Must be) every row in the value table.

I have a field in the table in which I need 6 digit numeric value (random and unique).

Please help me do this. 

  select ABS (checks (nude)% 99 99 99  < / Pre> 
 For phone number: 
 
  SELECT RIGHT ('000000' + CAST (ABS (checks (Nude)) 9999 99 AS varchar (6)), 6)  
 
 About NEWID as random as you can get in SQL Server. 
 
 However, if you want unique, you can You can also start from 000000 and go to 999999. Any random generator. 
 
 You can be unique or random Trustworthy, but both of these are not trusted

Comments

Post a Comment