SQL语句和存储过程 查询语句的流程控制
2007-11-11 07:40:02 来源:WEB开发网核心提示: 写好的存储过程如下createPROCEDUREPr_GetClass @TeacherIDintasDeclare @achar(50), @bchar(50), @cchar(50), @dchar(50), @echar(50)select@a=DRClass1,@b=DRClass2,@c=DRClass3,
写好的存储过程如下
create PROCEDURE Pr_GetClass
@TeacherID int
as
Declare @a char(50), @b char(50), @c char(50), @d char(50), @e char(50)
select @a=DRClass1, @b=DRClass2, @c=DRClass3, @d=DRClass4, @e=DRClass5 from Teacher Where TeacherID = @TeacherID
DROP TABLE classname
create table classname(classname char(50))
insert into classname (classname) values (@a)
if (@b is not null)
begin
insert into classname (classname) values (@b)
if (@c is not null)
begin
insert into classname (classname) values (@c)
if (@d is not null)
begin
insert into classname (classname) values (@d)
if (@e is not null)
begin
insert into classname (classname) values (@e)
end
end
end
end
select * from classname
go
2 连表查询
我有三个表
KJ表
KJID
TeacherID
..........................................................
Teacher表
TeacherID
TeacherName
CollageID
.........................................................
Collage表
CollageID
CollageName
我想写一个SQL语句,查询所有的KJ,根据KJ的TeacherID查到TeacherName,同时根据TeacherID查到Teacher,Teacher的CollageID查到Collage,最后生成的数据集里KJ的属性里除了本身的KJName以外,还想加上TeacherName,CollageName。
语句如下
SELECT T1.KJName, T2.TeacherName, T3.CollageName
FROM KJ T1
LEFT JOIN Teacher T2 ON T2.TeacherID=T1.TeacherID
LEFT JOIN Collage T3 ON T3.CollageID=T2.CollageID
- ››sql server自动生成批量执行SQL脚本的批处理
- ››sql server 2008亿万数据性能优化
- ››SQL Server 2008清空数据库日志方法
- ››sqlserver安装和简单的使用
- ››SQL Sever 2008 R2 数据库管理
- ››SQL SERVER无法安装成功,sqlstp.log文件提示[未发...
- ››Sql Server中通过父记录查找出所有关联的子记录
- ››SqlServer触发器、存储过程和函数
- ››SQL Server 中的事务(含义,属性,管理)
- ››Sqlite数据库插入和读取图片数据
- ››Sql server 2005拒绝了对对象 'xx表' (数...
- ››Sql server 2005拒绝了对对象 'xx表' (数...
更多精彩
赞助商链接