Kizspy Question: 43
(Choose 1 answer)
Which of the following is not mentioned how does a local variable is defined using T-SQL?
A. The name of the local variable should begin with "@@" sign as the first character of its name.
B. A local variable is defined using T-SQL by using statement "DECLARE".
C. When a variable is first declared, its value is set to NULL. To assign a value to a variable, use the SET statement.
D. The data type of local variable is declared after its name and assigned a system-supplied or user-defined data type
and a length.