Select no=Identity(int,1,1),* Into TempTable From TableName Select * From TempTable Drop Table TempTable