Question

Describe in detail Variables in SQL?

Answer 1

A SQL variable is an object which can hold a single data value of a specific data types. It is used in batches and scripts.

DECLARE statement initializes a variable by assigning it a name and a data type.

DECLARE @VarA int