590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM #tempCgPlanProject where ProjectGUID IN (''''+(replace('60ca3a38-3ef7-e611-80b3-e04f43069c1a;8aafd33c-d1f8-e611-80b3-e04f43069c1a',';',''','''))+'''')
SELECT * FROM #tempCgPlanProject where ProjectGUID IN ('60ca3a38-3ef7-e611-80b3-e04f43069c1a','8aafd33c-d1f8-e611-80b3-e04f43069c1a')
select (''''+(replace('60ca3a38-3ef7-e611-80b3-e04f43069c1a;8aafd33c-d1f8-e611-80b3-e04f43069c1a',';',''','''))+'''')
SELECT (''''+(replace('60ca3a38-3ef7-e611-80b3-e04f43069c1a;8aafd33c-d1f8-e611-80b3-e04f43069c1a',';',''','''))+'''')
SELECT '60ca3a38-3ef7-e611-80b3-e04f43069c1a','8aafd33c-d1f8-e611-80b3-e04f43069c1a'
SELECT * FROM #tempCgPlanProject where ProjectGUID IN (SELECT ProjCod FROM(SELECT fs.AllItem AS ProjCod FROM dbo.fn_split(@ProjCodeList,';') AS fs) p1)
这样解决了 ,语句中的变量=以上字符串。DECLARE @sql NVARCHAR(MAX)= 'SELECT * FROM #tempCgPlanProject where ProjectGUID IN ('
+ ( ''''
+ ( REPLACE('60ca3a38-3ef7-e611-80b3-e04f43069c1a;8aafd33c-d1f8-e611-80b3-e04f43069c1a',
';', ''',''') ) + '''' ) + ')'
EXEC(@sql)