drop table classname
declare @TeacherID int
declare @a char(50)
declare @b char(50)
declare @c char(50)
declare @d char(50)
declare @e char(50)
set @TeacherID=1set @a = (Select DRClass1 From Teacher Where TeacherID = @TeacherID)
set @b = (Select DRClass2 From Teacher Where TeacherID = @TeacherID)
set @c = (Select DRClass3 From Teacher Where TeacherID = @TeacherID)
set @d = (Select DRClass4 From Teacher Where TeacherID = @TeacherID)
set @d = (Select DRClass5 From Teacher Where TeacherID = @TeacherID)create table classname(classname char(50))
insert into classname (classname) values (@a)
if (@b<>null)
begin
insert into classname (classname) values (@b) if (@c<>null)
begin
insert into classname (classname) values (@c) if (@d<>null)
begin
insert into classname (classname) values (@d)
if (@e<>null)
begin
insert into classname (classname) values (@e)
end
end
end
endselect * from classname我测试的结果是它直接把@a插入到新表里面,接下来没做任何的判断,然后就直接到了最后一句了,
select * from classname
麻烦各位大侠指导一下
declare @TeacherID int
declare @a char(50)
declare @b char(50)
declare @c char(50)
declare @d char(50)
declare @e char(50)
set @TeacherID=1set @a = (Select DRClass1 From Teacher Where TeacherID = @TeacherID)
set @b = (Select DRClass2 From Teacher Where TeacherID = @TeacherID)
set @c = (Select DRClass3 From Teacher Where TeacherID = @TeacherID)
set @d = (Select DRClass4 From Teacher Where TeacherID = @TeacherID)
set @d = (Select DRClass5 From Teacher Where TeacherID = @TeacherID)create table classname(classname char(50))
insert into classname (classname) values (@a)
if (@b<>null)
begin
insert into classname (classname) values (@b) if (@c<>null)
begin
insert into classname (classname) values (@c) if (@d<>null)
begin
insert into classname (classname) values (@d)
if (@e<>null)
begin
insert into classname (classname) values (@e)
end
end
end
endselect * from classname我测试的结果是它直接把@a插入到新表里面,接下来没做任何的判断,然后就直接到了最后一句了,
select * from classname
麻烦各位大侠指导一下
set @a = (Select DRClass1 From Teacher Where TeacherID = @TeacherID)
set @b = (Select DRClass2 From Teacher Where TeacherID = @TeacherID)
set @c = (Select DRClass3 From Teacher Where TeacherID = @TeacherID)
set @d = (Select DRClass4 From Teacher Where TeacherID = @TeacherID)
set @d = (Select DRClass5 From Teacher Where TeacherID = @TeacherID)
不觉得繁琐?直接
select @a=DRClass1, @b=DRClass2, @c=DRClass3, @d=DRClass4, @c=DRClass5 from Teacher Where TeacherID = @TeacherID
不是更简单?
你的方法很好,我一时胡涂,复制粘贴习惯了,就set了一堆了
另:
@b,@c,@d,@e都不是空的
if @c is not null
......
sunjian_qi(sonne) 能讲讲原因吗?
实在不好意思,帖子结了还要问问题。
上面那个SQL语句,怎么样写成存储过程啊?我试了一晚上都不行。