How to Get a value to 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 364 times

When you use the declare a variable using the DECLARE statement. The same variable can be used to store a value retrieved from the database and later can be used in your SQL Query.

How to Get a value to a Variable in SQL Server ?

For example , you want to retreive the value of the column JobTitle and store it in the variable "NewEmployeeJobTitle".

use AdventureWorks2014
DECLARE @NewEmployeeJobTitle nvarchar(50)
SELECT @NewEmployeeJobTitle = JobTitle FROM HumanResources.Employee where BusinessEntityID = 5

SELECT @NewEmployeeJobTitle as JobTitle


Also , ensure that at most one row is retrieved from the Query by using the PrimaryKey or the Unique Key in the WHERE clause.

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