Articles → SQL SERVER → Variables In SQL Server

Variables In SQL Server

In this article, we will discuss variables in SQL Server.

Purpose

Variables are placeholders to store values.

Syntax

DECLARE @variable_name data_type

Each variable name in SQL server starts with "@". For example, if I have to declare a variable for storing the value of number of rows in the table then we can declare it as: -

DECLARE @row_count INT

Here "DECLARE" is a keyword for declaring variables.

Setting Values

There are two different ways of setting the value in a variable: -

Using the "SET" keyword
Using the "SELECT" query

Let us discuss both ways of setting variable.

Using the "SET" keyword

Syntax:

SET @variable_name = val

Example:

SET @errormessage = 'Invalid User'

Using the "SELECT" query

Syntax:

SELECT 
  @variable_name = [column_Name | Aggregate function] 
FROM 
  table_name

Example:

SELECT 
  @row_count = count(*) 
FROM 
  user_information

Posted By -	Karan Gupta

Posted On -	Saturday, April 2, 2011

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**