34,588
社区成员
发帖
与我相关
我的任务
分享
--学生
create table stu(stuid int identity(1,1),stuno varchar(8000),
stuname varchar(8000),age int,gm varchar(8000))
insert into stu select 'a001','张三',18,'男'
insert into stu select 'a002','李四',18,'女'
insert into stu select 'a003','王五',18,'男'
--课程
create table sub(subno varchar(8000),subname varchar(8000))
insert into sub select '001','数学'
insert into sub select '002','语文'
insert into sub select '003','英语'
--信息
create table Infor(inforid int identity(1,1),stuno varchar(8000),subno varchar(8000))
insert into Infor select 'a001','002'
insert into Infor select 'a001','001'
insert into Infor select 'a002','001'
insert into Infor select 'a003','003'
--sql
declare @stuname varchar(8000),@age int,@gm varchar(8000),@sql varchar(8000),@sql2 varchar(8000)
select @stuname='张三',@age=18,@gm='男'
set @sql='select * from Infor a left join stu b on a.stuno=b.stuno left join sub c on a.subno=c.subno where b.stuname='''+@stuname+''' and b.gm='''+@gm+''' and b.age='''+cast(@age as varchar(8000))+''''
print @sql
exec (@sql)