krayknot (1/20/2009)

---

Paresh Prajapati (1/20/2009)

---

Can have script to generate 16 digit unique number which contain both character/Number..

which should be not duplicate in future also.

declare @random varchar(50)

set @random = newid()

print (@random)

select substring(@random,1, 16)