AND ArchivedTime is null OPEN relations FETCH NEXT FROM relations INTO @relation WHILE @fetch_status = 0 BEGIN - 열의 이름을 변경합니다. ...

'
                  AND ArchivedTime is null
                  OPEN relations
                  FETCH NEXT FROM relations INTO @relation
                  WHILE @@fetch_status = 0
                  BEGIN
                  -- 열의 이름을 변경합니다.
                  SET @tableChangeSql = N'EXEC sp_rename N''' + @relation + N'.[OtherActivityName]'', ''ReferenceName'', ''COLUMN'''
                  EXEC sp_executesql @tableChangeSql

                  SET @tableChangeSql = N'EXEC sp_rename N''' + @relation + N'.[OtherActivityID]'', ''ReferenceData'', ''COLUMN'''
                  EXEC sp_executesql @tableChangeSql

                  -- ReferenceType 및 LongReferenceData, 이 두 개의 새 열을 추가합니다.
                  SET @tableChangeSql = N'ALTER TABLE ' + @relation + N' ADD ReferenceType NVARCHAR(128) DEFAULT N''BizTalkService'' WITH VALUES, LongReferenceData NTEXT NULL'
                  EXEC sp_executesql @tableChangeSql

                  -- OtherActivityName이 'BizTalkOrchestration'이 아니면 ReferenceType을 'Activity'로 업데이트합니다.
                  SET @tableChangeSql = N'UPDATE ' + @relation + N' SET ReferenceType = N''Activity'' WHERE ReferenceName <> N''BizTalkOrchestration'''
                  EXEC sp_executesql @tableChangeSql
                  
                  -- OtherActivityName이 'BizTalkOrchestration'이면 ReferenceType을 'BizTalkService'로 업데이트합니다.
                  -- ReferenceName을 관리 서버 + 관리 데이터베이스 + 관계로 업데이트합니다.
                  SET @tableChangeSql = N'UPDATE ' + @relation + N' SET ReferenceName = N''' + @ReferenceName + N''' WHERE ReferenceName = N''BizTalkOrchestration'''
                  EXEC sp_executesql @tableChangeSql

              FETCH NEXT FROM relations INTO @relation
          END

          CLOSE relations
          DEALLOCATE relations
          GO

          -- 자리 표시자로서, 코드에서 수정됩니다.
          ALTER VIEW
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Español (España)
Spanish (Spain)
Français (France)
French (France)
日本語
Japanese
한국어
Korean