/
AstroJohn
/
MailRobot
Обзор
Документация
Войти
/
AstroJohn
/
MailRobot
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
DBProject/UpdateScripts/Script010.sql
25 строк
2 KB
AstroJohn
1st commit
11 сен 2024, 13:31
11 сен 2024, 13:31
0f57dc5
Код
Авторство
О чём код?
If col_length('dbo.SWLs', 'CountryID1') Is Null Alter Table SWLs Add [CountryID1] Varchar (10) Null If col_length('dbo.SWLs', 'OblID1') Is Null Alter Table SWLs Add [OblID1] Varchar (2) Null If col_length('dbo.SWLs', 'CountryID2') Is Null Alter Table SWLs Add [CountryID2] Varchar (10) Null If col_length('dbo.SWLs', 'OblID2') Is Null Alter Table SWLs Add [OblID2] Varchar (2) Null If col_length('dbo.SWLs', 'Mult11') Is Null Alter Table SWLs Add [Mult11] Varchar (10) Null If col_length('dbo.SWLs', 'Mult12') Is Null Alter Table SWLs Add [Mult12] Varchar (10) Null If col_length('dbo.SWLs', 'Mult13') Is Null Alter Table SWLs Add [Mult13] Varchar (10) Null If col_length('dbo.SWLs', 'Mult21') Is Null Alter Table SWLs Add [Mult21] Varchar (10) Null If col_length('dbo.SWLs', 'Mult22') Is Null Alter Table SWLs Add [Mult22] Varchar (10) Null If col_length('dbo.SWLs', 'Mult23') Is Null Alter Table SWLs Add [Mult23] Varchar (10) Null If col_length('dbo.SWLs', 'Date') Is Null Alter Table SWLs Add [Date] Datetime Null Alter Table Category Alter Column [Category] Nvarchar (255) Null Alter Table Category Alter Column [Description] Nvarchar (255) Null Drop Index [IX_LogFilesCategory__Category] On [dbo].[LogFilesCategory] Drop Index [IX_LogFilesCategory__Location] On [dbo].[LogFilesCategory] Alter Table LogFilesCategory Alter Column [Category] Nvarchar (255) Null Alter Table LogFilesCategory Alter Column [Location] Nvarchar (255) Null Create Nonclustered Index [IX_LogFilesCategory__Category] On [dbo].[LogFilesCategory]([Category] Asc) Create Nonclustered Index [IX_LogFilesCategory__Location] On [dbo].[LogFilesCategory]([Location] Asc) Alter Table LogFiles_BandResults Alter Column [Category] Nvarchar (255) Null