SELECT IDENTITY(int, 1,1) AS ID_Num ,* INTO NewTable FROM OldTable SELECT * FROM NewTable
SELECT IDENTITY(int, 1,1) AS ID_Num , * INTO NewTable FROM OldTableSELECT * FROM NewTable
1:如果有主键,比如是A,则可以如下 Select (select sum(1) from 表 where A <= t.A) as id,A,B,C,D from 表 t 2: 如果没有主键 Select identity(int,1,1) as id,* into #tmp from 表 Select * from #tmp Drop Table #tmp
一表有A,B,C,D等字段,可用一SQL语句取出,(Select A,B,C,D from TableName) 有没有方法在取回的数据里加一序号,即显示为 序号,A,B,C,D; 要求:在程序里用一个TQuery运行一个SQL语句搞掂。
有主键一句话就可以搞定,这就是我问主键的目的,也就是马可的第一个语句 Select (select sum(1) from 表 where A <= T.A) as id,A,B,C,D from 表 T
select * from #tem9
INTO NewTable
FROM OldTable
SELECT * FROM NewTable
INTO NewTable
FROM OldTableSELECT * FROM NewTable
Select (select sum(1) from 表 where A <= t.A) as id,A,B,C,D
from 表 t
2: 如果没有主键
Select identity(int,1,1) as id,* into #tmp from 表
Select * from #tmp
Drop Table #tmp
有没有方法在取回的数据里加一序号,即显示为 序号,A,B,C,D;
要求:在程序里用一个TQuery运行一个SQL语句搞掂。
Select (select sum(1) from 表 where A <= T.A) as id,A,B,C,D
from 表 T