Declare @tmp int
select @tmp=Max(b) from T
if @tmp =0
set @tmp=1
insert into T Select 1,Max(b),1*Max(b) From T
select @tmp=Max(b) from T
if @tmp =0
set @tmp=1
insert into T Select 1,Max(b),1*Max(b) From T
调试欢乐多
create table tn(a int,b int identity(1,1),c as a*b)--输入数据
insert into tn(a) select 1
select * from tn--结果
1 1 1
1 2 2
1 3 3
a*b=b呀
不知道你用这个语句来作什么啊?
insert into tn
values(1,1,1)
--动态插入值(@Num控制个数)
Declare @tmp int
Declare @Num int
set @Num=100
WHILE (@Num>=0)
begin
insert into Tn Select 1,Max(b)+1,1*(Max(b)+1) From Tn
set @Num=@Num -1
end--结果
select * from tn
order by b