How to Declare a variable in SQL Server ?

Published on August 20, 2016 by abundantcode

Filed under SQL Server

Last modified August 20, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 434 times

You will most likely declare a variable in the SQL Server and use it in the SQL Statements. You can use the DECLARE statement and specify the variable and datatype and optionally provide a default value.

For example , You can declare an NewEmployeeJobTitle variable using the DECLARE statement and provide a default value as ‘Chief Executive Officer’

DECLARE @NewEmployeeJobTitle nvarchar(50) = ‘Chief Executive Officer’;

This variable can later be used within the T-SQL Query.

use AdventureWorks2014
DECLARE @NewEmployeeJobTitle nvarchar(50) = 'Chief Executive Officer';
SELECT * FROM HumanResources.Employee
WHERE JobTitle = @NewEmployeeJobTitle

You can declare a variable without assigning a value for it in which case , the variable value will be NULL.


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

Here's a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel. How to hide...

Deleting all the hidden rows and columns in the active worksheet using VBA

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel usi...

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...