declare @SQL VARCHAR(MAX)
DECLARE @Wherestring VARCHAR(MAX)
SET @Wherestring=' and a.CreateDate between ''2012-5-3 0:00:00'' and ''2012-5-3 23:59:59'' '
SET @SQL= ' SELECT
(case a.OperateType when ''aa'' then a.NewCardNo else '' end) as bb,a.OldCardNo as cc
FROM dbo.CardRevisionHistoryOfResetCard as a LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID
WHERE 1 = 1 [email protected]+' UNION ALL '
SET @[email protected]+' SELECT
(case a.OperateType when ''aa'' then a.NewCardNo else '' end) as bb,a.OldCardNo as cc
FROM dbo.CardRevisionHistoryOfResetCard as a
INNER JOIN CardInfo as c ON a.OldCardNo = c.CardNo or a.NewCardNo=c.CardNO LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID
WHERE 1 = 1 and c.IsLoss=0 and c.IsUntread=0 and c.CardTypeCode=1 [email protected]+' '
消息 102，级别 15，状态 1，第 4 行
'2012' 附近有语法错误。
------解决方案--------------------
CASE中为空需要''''不是''
- SQL code
SET @SQL= ' SELECT (case a.OperateType when ''aa'' then a.NewCardNo else '''' end) as bb,a.OldCardNo as cc FROM dbo.CardRevisionHistoryOfResetCard as a LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID WHERE 1 = 1 [email protected]+' UNION ALL 'SET @[email protected]+' SELECT (case a.OperateType when ''aa'' then a.NewCardNo else '''' end) as bb,a.OldCardNo as cc FROM dbo.CardRevisionHistoryOfResetCard as a INNER JOIN CardInfo as c ON a.OldCardNo = c.CardNo or a.NewCardNo=c.CardNO LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID WHERE 1 = 1 and c.IsLoss=0 and c.IsUntread=0 and c.CardTypeCode=1 [email protected]+' '
------解决方案--------------------
else '' -> else ''''
