存储过程模糊查询

ALTER proc [dbo].[proc_SelectEInfo]
(
@id varchar (20),
@name varchar (30),
@sex char (4)
)
as
if(@id='' and @name='' and @sex='')
 select * from tb_Employee
else
begin
if(@id<>'')
--if (@id<>'' or @name<>'' or @sex<>'')
  select * from tb_Employee where ID like '%['+@id+']%'
else if(@name<>'')
   select * from tb_Employee where Name like '%['+@name+']%'
else
    select * from tb_Employee where Sex=@sex
end

 多表查询

ALTER PROCEDURE [dbo].[proc_SchHrkh]
    -- Add the parameters for the stored procedure here
    @t1 datetime,
    @t2 datetime
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    --
    SELECT  h.id 单据编号, h.employid as 员工ID,p.psnName as 姓名, b.department as 部门,h.kctime as 日期,h.shijian as 原因,h.fakuan as 金额,h.remark as 备注 
    FROM (SELECT * FROM hrms_jilv_kaocha WHERE kctime>= @t1 AND kctime<=@t2) as h, person as p, base_department as b where  h.did=b.id and h.employid=p.id 
    group by h.kctime,b.department,h.id,h.did, h.employid,p.psnName,h.kctime,h.shijian,h.fakuan,h.remark 
    order by h.kctime desc
END