多条件组合查询 非常好的一段存储过程SQL代码

CREATE PROCEDURE UP_PM_Drive_GetList_Query
@DriveDepartmentID nvarchar(10),
@DriveHangdaoID nvarchar(10),
@DriveBanciID nvarchar(10),
@begin datetime,
@end datetime

 AS
declare @strSql varchar(8000)
set  @strSql = '
 SELECT PM_Drive.DriveID,PM_Department.DepName, PM_38._38Type,
      PM_Hangdao.HangdaoName, PM_Drive.DriveKaituohangdao,
      PM_Drive.DriveOutput, PM_Drive.DriveTime
FROM PM_Drive INNER JOIN
      PM_Department ON
      PM_Drive.DriveDepartmentID = PM_Department.DepID INNER JOIN
      PM_38 ON PM_Drive.DriveBanciID = PM_38._38ID INNER JOIN
      PM_Hangdao ON PM_Drive.DriveHangdaoID = PM_Hangdao.HangdaoID
      WHERE  PM_Drive.DriveTime  between   '''+convert(varchar(30), @begin)+'''      and   '''+convert(varchar(30), @end)+'''  '
 
if( @DriveDepartmentID<>'')
begin
set  @strSql=@strSql+'and   PM_Drive.DriveDepartmentID= '+convert(varchar(10), @DriveDepartmentID)
end

 

if(@DriveHangdaoID<>'')
begin
set  @strSql=@strSql+'and   PM_Drive.DriveHangdaoID='+convert(varchar(10), @DriveHangdaoID)
end

 

if(@DriveBanciID<>'')
begin
set  @strSql=@strSql+' and   PM_Drive.DriveBanciID='+convert(varchar(10), @DriveBanciID)
end

 

exec(@strSql)

GO