剛開始以為是一個單引號，或者是一個雙引號， 沒想到是兩個單引號，郁悶

?

例如下面

    
      SET
    
     @SQLOne = 
    
      '

INSERT INTO #ddlist(DDGuid,HBGUID,EnumDDLY,DDType,LYDH,DJBH,RQ,SJJE,WLFY,SumMoney,Audit,Auditor,AuditTime,Record,RecordTime)

SELECT dbo.DD.Guid AS DDGuid, dbo.DD.HBGUID, (CASE dbo.DD.DDLY WHEN 0 THEN '
    
    
      '系統網站'
    
    
      ' WHEN 1 THEN '
    
    
      '淘寶網站'
    
    
      ' WHEN 2 THEN '
    
    
      '其他'
    
    
      ' WHEN 3 THEN '
    
    
      '淘寶分銷'
    
    
      ' WHEN 4 THEN '
    
    
      '拍拍網站'
    
    
      '  

        WHEN 5 THEN '
    
    
      '京東商城'
    
    
      ' WHEN 6 THEN '
    
    
      '當當網站'
    
    
      ' WHEN 7 THEN '
    
    
      'E鏈通'
    
    
      ' WHEN 8 THEN '
    
    
      '商派網站'
    
    
      ' WHEN 9 THEN '
    
    
      'POS門店'
    
    
      '  

        WHEN 10 THEN '
    
    
      '商派分銷王'
    
    
      ' WHEN 11 THEN '
    
    
      '一號店'
    
    
      ' WHEN 12 THEN '
    
    
      '凡客商城'
    
    
      ' WHEN 13 THEN '
    
    
      '品聚網站'
    
    
      ' WHEN 14 THEN '
    
    
      '卓越亞馬遜'
    
    
      '   

        WHEN 16 THEN '
    
    
      '郵樂商城'
    
    
      ' WHEN 17 THEN '
    
    
      '好樂買'
    
    
      ' WHEN 18 THEN '
    
    
      'QQ網購'
    
    
      ' WHEN 19 THEN '
    
    
      'QQ彩貝'
    
    
      ' WHEN 20 THEN '
    
    
      '阿里巴巴'
    
    
      ' WHEN 21 THEN '
    
    
      '優購'
    
    
      '  

        WHEN 22 THEN '
    
    
      '新蛋網'
    
    
      ' WHEN 23 THEN '
    
    
      '聚美優品'
    
    
      ' WHEN 24 THEN '
    
    
      '商派易開店'
    
    
      '     

        WHEN 100 THEN '
    
    
      '樂蜂網'
    
    
      '  WHEN 101 THEN '
    
    
      'ERPFX'
    
    
      ' END)  

                       AS EnumDDLY, '
    
    
      '銷售訂單'
    
    
      ' AS DDType,LYDH,dbo.DD.DJBH,pt.SMRQ AS RQ,SJJE,WLFY,ISNULL(SJJE,0)+ISNULL(WLFY, 0)-ISNULL(RLJE,0) AS SumMoney, 0  AS Audit,null AS Auditor, NULL AS AuditTime,0 as Record, NULL AS RecordTime 

                       FROM dbo.DD

                       LEFT OUTER JOIN dbo.DD_ShenHe AS SH WITH(NOLOCK) ON dbo.DD.GUID = SH.GUID

                       LEFT OUTER JOIN dbo.DD_Delivery AS Dli WITH(NOLOCK) ON dd.GUID = Dli.GUID

                       LEFT OUTER JOIN dbo.DD_Print AS pt WITH(NOLOCK) ON dd.GUID = pt.GUID

                       WHERE ISNULL(Dli.FH, 0) = 1 AND

                       ((dbo.DD.HBGUID IS NULL AND ISNULL(SH.ZF,0)= 0) OR (dbo.DD.HBGUID IS NOT NULL AND ISNULL(SH.ZF,0)=1 AND SH.ZFR = '
    
    
      '系統合并'
    
    
      '))'
    
    
      EXEC
    
    (@SQLOne);
  

存儲過程中對于文本是兩個單引號，而不是一個單引號或者一個雙引號