where charindex('',''+cast(a.state_flag as varchar(2))+'','','','+@entity_trigger_status+','')>0

解决方案 »

  1.   

    where charindex(''','''+cast(a.state_flag as varchar(2))+''',''',''','''+@entity_trigger_status+''',''')>0
      

  2.   

    charindex('',''+cast(a.state_flag as varchar(2))+'','','','+@entity_trigger_status+','')>
      

  3.   

    'where charindex('',''+cast(a.state_flag as varchar(2))+''','','','''+@entity_trigger_status+''','')>0'
      

  4.   

    'where charindex('',''+cast(a.state_flag as varchar(2))+'','','',''+@entity_trigger_status+'','')>0'
      

  5.   

    charindex(','''''+cast(a.state_flag as varchar(2))+''''','
    ,','''''+@entity_trigger_status+''''',')>0