--根据名称查询产品
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查询不出结果,应该怎么改啊?
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查询不出结果,应该怎么改啊?
if(@khname is null and @qyname is null and @bmname is null)
begin
select语句
end
else 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
begin
select语句
end
空格不属于null.
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语句
endif(@qyname is null and @khname is null and @bmname is not null and @cpname is not null)
begin
select语句
endif(@qyname is null and @bmname is null and @cpname is not null and @khname is not null)
begin
select语句
endif(@khname is null and @qyname is null and @bmname is null and @cpname is not null)
begin
select语句
end
go