[T-SQL] Row num in sql server

Wednesday, August 1, 2007

Select IDENTITY(int, 1, 1) as row_num,Region_Code,Region_Name
into #temp_region
from ADM_REGIONS

Select * from #temp_region

Unknown said...: Hi abbsa on what tools and technologies do you work in Systems, do you work in VB 6.0 in Systems and on what tools were you working in 360 degreez,on what technologies have you worked professionally.; August 11, 2007 at 12:01 AM