Answer to Question #170396 in Databases | SQL | Oracle | MS Access for william

Question

Define in detail Variables and their types also define the variables of SQL Server.

Answer 1

Variable is a named piece in the computer memory which contains the particular information inside it. The amount of memory allocation is depending on the variable type.

Generally we use 6 types of data type-

• string/array:
• character:
• Integer:
• Float
• boolean
• enumerated type
• tree

SQL variables is a data type which holds the single datatype value of specific type.