34,590
社区成员
发帖
与我相关
我的任务
分享
select a.col1,a.col2...from tb1 a,tb2 b where a.col1='a'and b.col1='b'
create proc findcontract
@contractnum int=null,
@staffName nvarchar(50)=null
as
begin
select contractid,staffName,Num from @a a,@b b
where a.id=b.id
and (@contractnum is null or @contractnum=[合同编号])
and (@staffName is null or @staffName=[品名])
end
create proc P_test
@合同号 nvarchar(20),
@品名 nvarchar(50)
as
select a.*,b.* from ta a,tb b where a.A1=b.B2
and a.合同号=ISNULL(NULLIF(@合同号,''),a.合同号)
AND b.品名=ISNULL(NULLIF(@品名,''),b.品名)
select a.*,b.*
from ta a join tb b on a.编号=b.合同编号
where a.合同号=isnull(@合同号,a.合同号) and b.品名=isnull(@品名,b.品名)
select a.*,b.*
from ta a join tb b on a.编号=b.编号
where a.合同号=isnull(@合同号,a.合同号) and b.品名=isnull(@品名,b.品名)
select * from ta a
inner join tb b on a.a1=b.b2
where a.a1='a' and b.b1='b'
select a.*,b.* from ta a,tb b where a.A1=b.B2 a.a1='a' and b.b1='b'