Синтаксис оператора DECLARE имеет вид:
(Отметьте один правильный вариант ответа.)
Варианты ответа
DECLARE {{ @local_variable data_type } | { @cursor_variable_name CURSOR } | { table_type_definition } } [ ,...n] < table_type_definition > ::= TABLE ( { < column_definition > | < table_constraint > } [ ,... ] ) < column_definition > ::= column_name scalar_data_type [ COLLATE collation_name ] [ [ DEFAULT constant_expression ] | IDENTITY [ ( seed, increment ) ] ] [ ROWGUIDCOL ] [ < column_constraint > ] < column_constraint > ::= { [ NULL | NOT NULL ] | [ PRIMARY KEY | UNIQUE ] | CHECK ( logical_expression ) } < table_constraint > ::= { { PRIMARY KEY | UNIQUE } ( column_name [ ,... ] ) | CHECK ( search_condition ) }(Верный ответ)
DECLARE {{ @local_variable data_type } | { @cursor_variable_name CURSOR } | { table_type_definition } } [ ,...n] < table_type_definition > ::= TABLE ( { < column_definition > [ ,... ] ) < column_definition > ::= column_name scalar_data_type [ COLLATE collation_name ] [ [ DEFAULT constant_expression ] | IDENTITY [ ( seed, increment ) ] ] [ ROWGUIDCOL ] [ < column_constraint > ] < column_constraint > ::= { [ NULL | NOT NULL ] | [ PRIMARY KEY | UNIQUE ] | CHECK ( logical_expression ) }
DECLARE {{ @local_variable data_type } } [ ,...n]