有關SQL語句?

[slyNS]

SELECT TOP 1000 (?自增號),Id,Name FROM Table
請問自增號怎麼實現?

[yujohny]

select top 1000 IDENTITY(INT,1,1) NewID,ID,Name into #tmp from Table
select * from #tmp

[zjcxc]

如果表中有主键,用下面的语句:

select top 1000 自增号=(select sum(1) from table1 where 主键<=a.主键),id,name from table1 a

[zjcxc]

如果表中无主键.

--生成自增号
select top 1000 自增号=identity(int,1,1),id,name into #tb from table1
--查询
select * from #tb
--删除临时表
drop table #tb

[wzh1215]

create table #b(no [int] IDENTITY (1, 1) NOT NUL,id,name)
select top 1000 id,name into #b
select * from #b
drop table #b

[wzh1215]

create table #b(no [int] IDENTITY (1, 1) NOT NULL,id,name)
select top 1000 id,name into #b
select * from #b
drop table #b