title: How do I autogenerate confirmation number in SQLServer?
body: <p>I need to autogenerate an order confirmation number with SQL Server 2008 and display it on a webpage.  I have set a column called confirmationnumber and assigned it a uniqueidentifier. Is this the right way to do it?</p>