Most of the SQL Developers, Programmers know how to create an IDENTITY column in SQL Server and also what is its purpose and why is it used? But here I am going to explain how to create an IDENTITY column in Select statement.
Note: we can use this Query only in select statement where we are creating a table in a select statement.
prasad
13 years agoHi varun ,
This is fine , is there any way to select incremental id with out inserting in to another table. one way i am using is ROW NUMBER for incremental column in select , is there any other way to do this ?