Discussion in 'General Developer Questions' started by ks9072, Oct 8, 2003.
How to get the same from MSSQL
Oracle : select rownum,empno from emp;
MSSQL : ?
Select IDENTITY(int, 1,1) id, * INTO #Temp from authors
Select * from #Temp
May take help of this DBJournalhttp://www.databasejournal.com/features/mssql/article.php/2244821 article. And this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133 too
Separate names with a comma.