if else判断根据空值查询
--根据名称查询产品
create proc yg_GetcpInfobyMc
(
@cpname varchar(100),
@qyname varchar(500),
@bmname varchar(500),
@khname varchar(500)
)
as
if(@bmname is null and @khname is null)
begin
begin
select语句
end
else if(@qyname is null and @khname is null)
begin
select语句
end
else if(@qyname is null and @bmname is null)
begin
select语句
end
else if(@khname is null and @qyname is null and @bmname is null)
begin
select语句
end
go
查询不出结果，应该怎么改啊？
[解决办法]
-- try
create proc yg_GetcpInfobyMc
(
@cpname varchar(100),
@qyname varchar(500),
@bmname varchar(500),
@khname varchar(500)
)
as
if(@bmname is null and @khname is null and @cpname is not null and @qyname is not null)
begin
select语句
end
if(@qyname is null and @khname is null and @bmname is not null and @cpname is not null)
begin
select语句
end
if(@qyname is null and @bmname is null and @cpname is not null and @khname is not null)
begin
select语句
end
if(@khname is null and @qyname is null and @bmname is null and @cpname is not null)
begin
select语句
end
go
