This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I want to create an auto-increament like thing in MS Sql Server2000 (which is possible with MySql). I am not sure whether that functionality is there in the SQL Server 2000. I think we use sequence in Oracle to do the same thing. The column will have nos generated automatically which otherwise would increament by themselves as the data is inserted into the row.