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 1741 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
GO
DECLARE @NewEmployeeJobTitle nvarchar(50)
SELECT @NewEmployeeJobTitle = JobTitle FROM HumanResources.Employee where BusinessEntityID = 5

SELECT @NewEmployeeJobTitle as JobTitle

SNAGHTML93535ad

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


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...