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

Nov 14 2009 5:20 AM

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?

Answers (1)

value not changing

web application development