Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Проверка поля guid uniqueidentifier:-- @tmp_NULLABLE: 1 @strNULLABLE: NULL
- -- @tmp_PRECISION: 0, @tmp_SCALE: 0, @tmp_RADIX: -1
- IF COL_LENGTH( 'as_comments', 'guid') IS NULL
- BEGIN
- ALTER TABLE as_comments
- ADD [guid] uniqueidentifier (max) NULL
- END
- -- Проверка поля hasCheck bit:-- @tmp_NULLABLE: 1 @strNULLABLE: NULL
- -- @tmp_PRECISION: 0, @tmp_SCALE: 0, @tmp_RADIX: -1
- IF COL_LENGTH( 'as_comments', 'hasCheck') IS NULL
- BEGIN
- ALTER TABLE as_comments
- ADD [hasCheck] bit NULL
- END
- -- Проверка поля checked datetime:-- @tmp_NULLABLE: 1 @strNULLABLE: NULL
- -- @tmp_PRECISION: 0, @tmp_SCALE: 0, @tmp_RADIX: -1
- IF COL_LENGTH( 'as_comments', 'checked') IS NULL
- BEGIN
- ALTER TABLE as_comments
- ADD [checked] datetime NULL
- END
- -- Проверка поля checkedBy nvarchar:-- @tmp_NULLABLE: 1 @strNULLABLE: NULL
- -- @tmp_PRECISION: 64, @tmp_SCALE: 0, @tmp_RADIX: -1
- IF COL_LENGTH( 'as_comments', 'checkedBy') IS NULL
- BEGIN
- ALTER TABLE as_comments
- ADD [checkedBy] nvarchar (64) NULL
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement