Sql Server Procedure 多条件查询

create procedure proc_search
(@DName varchar(20),@GName varchar(20),@PName varchar(20))
as
begin
select d.DeptName bc,g.GroupName xc,p.PName pn from Patient p 
                             inner join [Group] g on (p.GroupNo= g.GroupNo)
                             inner join Department d