SQL字符串模糊查询

最新推荐文章于 2024-07-09 14:57:05 发布

原创最新推荐文章于 2024-07-09 14:57:05 发布 · 697 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql

DECLARE @_strSql NVARCHAR(4000)

SET @_strSqlSub1 =' AND ['+@SelectedType
      +'] Like ''%'+@SelectedTypeValue+'%'''
SET @_StrSqlSub2 =' AND MachineRegist_ID = '
      +''''+@MachineRegist_ID+''''
SET @_StrSqlSub4 =' AND Time >= '
      +''''+@StartDate+''''
SET @_StrSqlSub5 =' AND Time <= '
      +''''+@EndDate+''''
SET @_strSql= '
     Select *
     FROM v_Regist
     WHERE 1=1
     '
     + CASE @SelectedTypeValue
      WHEN ' ' THEN ' '
      ELSE @_strSqlSub1
       END