how to generate random ID for primary key in sql server 2005?
I am developing a post office online. And I want to generate random automatically a delivery number include 8 characters and begin with 2 characters "DN" when I insert a mail into database. How do I do that?
Kirtan PatelPosted Nov 14, 2009, 5:40 AM
you can do it following Way By Setting by default value binding Propertie
if my answer helps you then check "Do you like this answer check box" please :)
GENERATED VALUES
------------------------
DN40917
DN68458
DN75967
DN72372