14 lines
286 B
Transact-SQL
14 lines
286 B
Transact-SQL
DISABLE TRIGGER ALL ON T_DICTIONARYITEMBASE
|
|
GO
|
|
|
|
ALTER TABLE T_DICTIONARYITEMBASE ADD
|
|
[C_CODE] NVARCHAR (20) NULL,
|
|
[C_ORDER] INT NULL
|
|
GO
|
|
|
|
UPDATE T_DICTIONARYITEMBASE SET C_CODE = C_DICODE, C_ORDER = C_VALUE
|
|
GO
|
|
|
|
ENABLE TRIGGER ALL ON T_DICTIONARYITEMBASE
|
|
GO
|