It is a very good article,
but does not solve my purpose, according to those logics, i have to create an identiy value first (integer) then pass to UDF to create unique value.
What i want to do is generate a random alphanumeric value first and then insert into the record.
All this is because the current sql server 2012 generates integer auto increment values with huge gaps.
100, 102....
1000,1001, 1002...
sequences also experiences the same issue
thanks
No comments:
Post a Comment