实际上是在表中先插入一个空列sequence,然后是 declare @sequence int set @sequence = 0 update tb_name set sequence = @sequence , @sequence = @sequence + 1 就可以了
create table aa(Id int default dbo.f_aa(),name varchar(10),sorce int)create function f_aa() returns int as begin declare @i int select @i=max(id) from aa set @i=isnull(@i,0)+1 return @i endinsert into aa(name,sorce) select '张三',100insert into aa(name,sorce) select '李四',200insert into aa(name,sorce) select '王五',300select * from aaId name sorce ----------- ---------- ----------- 1 张三 100 2 李四 200 3 王五 300(3 行受影响)drop table aa drop function f_aa
7楼 create table aa(Id int default dbo.f_aa(),name varchar(10),sorce int) 这句是相当于为ID这个字段创建了一个触发器
select * from tb_name
declare @sequence int
set @sequence = 0
update tb_name
set sequence = @sequence , @sequence = @sequence + 1
declare @sequence int
set @sequence = 0
update tb_name
set sequence = @sequence , @sequence = @sequence + 1
就可以了
create table aa(Id int default dbo.f_aa(),name varchar(10),sorce int)create function f_aa()
returns int
as
begin
declare @i int
select @i=max(id) from aa
set @i=isnull(@i,0)+1
return @i
endinsert into aa(name,sorce) select '张三',100insert into aa(name,sorce) select '李四',200insert into aa(name,sorce) select '王五',300select * from aaId name sorce
----------- ---------- -----------
1 张三 100
2 李四 200
3 王五 300(3 行受影响)drop table aa
drop function f_aa
create table aa(Id int default dbo.f_aa(),name varchar(10),sorce int)
这句是相当于为ID这个字段创建了一个触发器
----------- ---------- -----------1 张三 100
2 李四 200
3 王五 300
4 YZ12-00001 4
4 YZ12-00002 4
4 YZ12-00003 4
4 CX32-00002 8
4 CX32-00003 8
4 CX32-00004 8
4 CX32-00005 8
4 CX32-00006 8
4 CX32-00007 8
4 ZH1-00060 111
4 CX37-00003 8
4 FH32-01010 9
4 FH32-01011 9
4 YZ32-00197 4
4 JD29-00056 2
4 CX32-00001 8
4 CX37-00001 8
4 CX37-00002 8
4 ZH32-00527 3
4 CX37-00004 8
2 李四 200
3 王五 300
4 YZ12-00001 4
4 YZ12-00002 4
4 YZ12-00003 4
4 CX32-00002 8
4 CX32-00003 8
4 CX32-00004 8
4 CX32-00005 8
4 CX32-00006 8
4 CX32-00007 8
4 ZH1-00060 111
4 CX37-00003 8
4 FH32-01010 9
4 FH32-01011 9
4 YZ32-00197 4
4 JD29-00056 2
4 CX32-00001 8
4 CX37-00001 8
4 CX37-00002 8
4 ZH32-00527 3
4 CX37-00004 8