拼字sql語句隨筆

標籤：blog   ar   div   sp   log   c   sql   r   as   

  DECLARE @str NVARCHAR(1000)=‘SELECT * FROM dbo.V_MicroUserInfo ‘,@where VARCHAR(1000)=‘ where  1=1‘  DECLARE @Nature VARCHAR(200)=‘河南|周口‘  SET @where+=‘ And ‘‘‘[email protected]+‘‘‘ like ‘‘%‘‘+HuJiString+ ‘‘%‘‘  ‘  SET @[email protected];  PRINT @str   EXEC sys.sp_executesql @str    SELECT * FROM dbo.V_MicroUserInfo  where  1=1 And ‘河南|周口市‘ like ‘%‘+HuJiString+ ‘%‘ AND CvNumber=797024  DECLARE @Nature VARCHAR(200)=‘北京|北京,河北|石家莊,山東|濟南‘  SELECT * FROM dbo.V_MicroUserInfo  WHERE @Nature LIKE ‘%‘+HuJiString+‘%‘   SELECT * FROM dbo.V_MicroUserInfo  where  1=1 And ‘北京|北京,河北|石家莊,山東|濟南‘ like ‘%‘+HuJiString+ ‘%‘ 

　　

拼字sql語句隨筆