Transact-SQL reference for using DECLARE to define local variables for use in a batch or procedure. Variables are declared in the body of a batch or procedure with the DECLARE statement and are ...

The same subset of information that is used to define a table in CREATE TABLE. The table declaration includes column definitions, names, data types, and constraints. The only constraint types allowed ...