declare @TYPE varchar(20)
set @TYPE='1'select case
when @TYPE='1'
then
insert into A(indust,200301)
values('1','1')when @TYPE='2'
then
insert into A(indust,200302)
values('1','2')when @TYPE='3'
then
insert into A(indust,200303)
values('1','3')end
这个怎么写
就是根据前面的值,把不同的值插入不同的栏位
set @TYPE='1'select case
when @TYPE='1'
then
insert into A(indust,200301)
values('1','1')when @TYPE='2'
then
insert into A(indust,200302)
values('1','2')when @TYPE='3'
then
insert into A(indust,200303)
values('1','3')end
这个怎么写
就是根据前面的值,把不同的值插入不同的栏位
set @TYPE='1'if @TYPE='1' then
insert into A(indust,200301)
values('1','1')else if @TYPE='2' then
insert into A(indust,200302)
values('1','2')else if @TYPE='3' then
insert into A(indust,200303)
values('1','3')
declare @TYPE varchar(20)
set @TYPE='1'IF @TYPE='1'
BEGIN
insert into A(indust,200301)
values('1','1')
END
IF @TYPE='2'
BEGIN
insert into A(indust,200302)
values('1','2')
END
IF @TYPE='3'
BEGIN
insert into A(indust,200303)
values('1','3')END
set @TYPE='1'if @TYPE='1'
BEGINinsert into test(ID,[200301])
values('1','1')
endelse if @TYPE='2'
BEGIN
insert into test(ID,[200302])
values('1','2')
endelse if @TYPE='3'
BEGIN
insert into test(ID,[200303])
values('1','3')
end