AND ArchivedTime is null OPEN relations FETCH NEXT FROM relations INTO @relation WHILE @fetch_status = 0 BEGIN - Cambie el ...

'
                  AND ArchivedTime is null
                  OPEN relations
                  FETCH NEXT FROM relations INTO @relation
                  WHILE @@fetch_status = 0
                  BEGIN
                  -- Cambie el nombre de las columnas
                  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

                  -- Agregue dos columnas nuevas: ReferenceType y LongReferenceData
                  SET @tableChangeSql = N'ALTER TABLE ' + @relation + N' ADD ReferenceType NVARCHAR(128) DEFAULT N''BizTalkService'' WITH VALUES, LongReferenceData NTEXT NULL'
                  EXEC sp_executesql @tableChangeSql

                  -- Actualice ReferenceType a 'Activity' cuando OtherActivityName no sea 'BizTalkOrchestration'
                  SET @tableChangeSql = N'UPDATE ' + @relation + N' SET ReferenceType = N''Activity'' WHERE ReferenceName <> N''BizTalkOrchestration'''
                  EXEC sp_executesql @tableChangeSql
                  
                  -- Actualice ReferenceType a 'BizTalkService' cuando OtherActivityName sea 'BizTalkOrchestration'
                  -- Actualice ReferenceName a servidor de administración + base de datos de administración + relación
                  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

          -- Marcador de posición; se modificará en el código
          ALTER VIEW
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Español (España)
Spanish (Spain)
Français (France)
French (France)
日本語
Japanese
한국어
Korean