Best Programming Master

SQL is a language that is used to manage relational databases. It provides a facility for easily declaring and using variables. We can use variables for storing temporary values in memory for performing calculations. In SQL variables can be used in the same way we use in any other programming language. SQL Declare Variable In SQL we use DECLARE statements for declaring variables. Let’s see its syntax: Syntax: DECLARE @variable_name data_type; The above syntax is self explanatory so no need to explain. Example: DECLARE @marks int; Here I have declared a variable with the name marks and type int . SQL Assign Variable I hope you got the idea about declaring variables now let’s have a look at how to assign some value. Syntax: SET @variable_name = value; The SET statement is used for assigning some value to a variable in SQL. Example: SET @marks = 80; As we declared a variable and assigned a value to it, now let’s take a look at how to use it with a SELECT statement. SEL