Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Generating Numbers

Author  Topic 

grahil23
Starting Member

1 Post

Posted - 2007-05-12 : 14:22:46
A simple question! I would like to create a database that creates say serial numbers and saves them to a table. If poss I would like to create them on demend and not duplicate.....

I have blank page syndrome!!!!

Thanks in advance

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-12 : 18:35:45
Take look at identity column, sql will generate int number for that column automatically.
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2007-05-13 : 02:45:29
http://www.sqlteam.com/item.asp?ItemID=26939

Chirag

http://chirikworld.blogspot.com/
Go to Top of Page
   

- Advertisement -