how to generate random ID for primary key in sql server 2005?

Question

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 Patel · Answer

Hi Friend 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