如何在MSSQL过程中解决此语法错误

Question

我有一个错误

在关键字“ set”'

附近的错误语法

已经声明了所有变量

BEGIN
 CASE WHEN TEMPLATE_NAME =  'SUCCESS'
     SET @vBody = CASE  @VAR2
     WHEN 'InterfaceNo'
         THEN  REPLACE(@vBody, '#{InterfaceNo}', @b_InterfaceNo)
     WHEN 'AgentJobName'
         THEN REPLACE(@vBody, '#{AgentJobName}', @b_AgentJobName)
     WHEN 'PackageID'
         THEN REPLACE(@vBody, '#{PackageID}', @b_PackageID)
     WHEN 'PackageName'
         THEN REPLACE(@vBody, '#{PackageName}', @b_PackageName)
     WHEN 'ExecutionInstanceGUID'
         THEN REPLACE(@vBody, '#{ExecutionInstanceGUID}', @b_ExecutionInstanceGUID)
     WHEN 'ExecuteStartTime'
         THEN REPLACE(@vBody, '#{ExecuteStartTime}', @b_ExecuteStartTime)
     WHEN 'SourceFilePath'
         THEN REPLACE(@vBody, '#{SourceFilePath}', @b_SourceFilePath)
     WHEN 'SourceTableName'
         THEN REPLACE(@vBody, '#{SourceTableName}', @b_SourceTableName)
     WHEN 'BackupFilePath'
         THEN REPLACE(@vBody, '#{BackupFilePath}', @b_BackupFilePath)
     WHEN 'DataOwner'   
          THEN REPLACE(@vBody, '#{DataOwner}', @b_DataOwner)
 END

Answer 1

BEGIN
        CASE WHEN TEMPLATE_NAME =  'SUCCESS'
                 THEN  @vBody  
             WHEN 'InterfaceNo'
                 THEN  REPLACE(@vBody, '#{InterfaceNo}', @b_InterfaceNo)
             WHEN 'AgentJobName'
                 THEN REPLACE(@vBody, '#{AgentJobName}', @b_AgentJobName)
             WHEN 'PackageID'
                 THEN REPLACE(@vBody, '#{PackageID}', @b_PackageID)
             WHEN 'PackageName'
                 THEN REPLACE(@vBody, '#{PackageName}', @b_PackageName)
             WHEN 'ExecutionInstanceGUID'
                 THEN REPLACE(@vBody, '#{ExecutionInstanceGUID}', @b_ExecutionInstanceGUID)
             WHEN 'ExecuteStartTime'
                 THEN REPLACE(@vBody, '#{ExecuteStartTime}', @b_ExecuteStartTime)
             WHEN 'SourceFilePath'
                 THEN REPLACE(@vBody, '#{SourceFilePath}', @b_SourceFilePath)
             WHEN 'SourceTableName'
                 THEN REPLACE(@vBody, '#{SourceTableName}', @b_SourceTableName)
             WHEN 'BackupFilePath'
                 THEN REPLACE(@vBody, '#{BackupFilePath}', @b_BackupFilePath)
             WHEN 'DataOwner'   
                  THEN REPLACE(@vBody, '#{DataOwner}', @b_DataOwner)
         END  AS RESULT
END