Select @@IDENTITY或 declare @id int select @id=max(id) from tablename set @id=@ida+1
要不建立一個虛擬字段。 declare @id int select identity(int,1,1) IDD ,* into #temp from tablenameselect @id=id from tablename IDD in(select max(IDD) from tablename)set @id=@id+1
@id加一就在插入數據時提前知道此ID的值看情況而定要不要加1
declare @id select @id=id from insertedinsered 是一张特殊的表,保存有你刚插入或修改的记录的副本
insert into tab_name(字段列表) values (值列表)
select @id = @@identity
declare @id int
select @id=max(id)
from tablename
set @id=@ida+1
declare @id int
select identity(int,1,1) IDD ,* into #temp
from tablenameselect @id=id
from tablename IDD in(select max(IDD) from tablename)set @id=@id+1
select @id=id from insertedinsered 是一张特殊的表,保存有你刚插入或修改的记录的副本