UPDATE TABLE1
SET b = 'CHARINDEX(',' + substring(CAST(C.Issue AS varchar(8)), 1, 2) + ',',A.IncludeIssue) > 0)'b为字符型
我想将b列中的内容被更新为:CHARINDEX(',' + substring(CAST(C.Issue AS varchar(8)), 1, 2) + ',',A.IncludeIssue) > 0) 但是MS SQL 老报错,将单引号改为双引号 也不能解决,望高手指点
SET b = 'CHARINDEX(',' + substring(CAST(C.Issue AS varchar(8)), 1, 2) + ',',A.IncludeIssue) > 0)'b为字符型
我想将b列中的内容被更新为:CHARINDEX(',' + substring(CAST(C.Issue AS varchar(8)), 1, 2) + ',',A.IncludeIssue) > 0) 但是MS SQL 老报错,将单引号改为双引号 也不能解决,望高手指点
SET b = 'CHARINDEX('','' + substring(CAST(C.Issue AS varchar(8)), 1, 2) + '','',A.IncludeIssue) > 0)'
UPDATE TABLE1
SET b = select 'CHARINDEX('','' + substring(CAST(C.Issue AS varchar(8)), 1, 2) + '','',A.IncludeIssue) > 0)'
SET b = 'CHARINDEX('','' + substring(CAST(C.Issue AS varchar(8)), 1, 2) + '','',A.IncludeIssue) > 0)'