(转)SQL Server多条件查询经典例子

这是一个不错的例子，特转载分享之。
 
------------表中的字段---------------
CREATE TABLE [dbo].[stuInfo] (
[FNumber] [int] IDENTITY(1,1) NOT NULL ,
[FName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FNameen] [varchar] (35) COLLATE Chinese_PRC_CI_AS ,
[FSex] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FEducation] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FCardID] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FBirDate] [datetime] NOT NULL ,
[FTech] [nvarchar](50) COLLATE Chinese_PRC_CI_AS ,
[FSubject] [nvarchar](50) COLLATE Chinese_PRC_CI_AS,
[FJiF] [nvarchar](100)COLLATE Chinese_PRC_CI_AS,
[FJobAdd][nvarchar](100)COLLATE Chinese_PRC_CI_AS,
[FExamNum][varchar](30)COLLATE Chinese_PRC_CI_AS NOT NULL,
[FServerNum] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FExamDate] [datetime] NOT NULL ,
[FIsAE] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
----------存储过程-------------------------
IF EXISTS(SELECT *from SYSOBJECTS WHERE NAME='PROC_Look')
DROP PROC PROC_Look
GO
CREATE PROC PROC_Look
@FName NVARCHAR(30)=null,
@FNameen VARCHAR(35)=null,
@FCardID CHAR(18)=null,
@FExamNum NVARCHAR(30)=null,
@FServerNum NVARCHAR(30)=null,
@FSex CHAR(1)=null,
@FEducation NVARCHAR(20)=null,
@FIsAE CHAR(1)=null,
@FTech NVARCHAR(50)=null,
@FSubject NVARCHAR(50)=null,
@FJiF NVARCHAR(100)=null,
@FJobAdd NVARCHAR(100)=null,
@FStartTime VARCHAR(20)=null,
@FEndTime VARCHAR(20)=null
AS
declare @sqlStr varchar(500)
        declare @man char(2)
        declare @wom char(2)
        declare @is char(2)
        declare @no char(2)
        set @man ='男'
        set @wom ='女'
        set @is ='是'
        set @no ='否' if