gjshah7254
6/19/2014 - 3:10 AM

Define a sql Variable , store/assign a value and re-use variable

Define a sql Variable , store/assign a value and re-use variable

create variable and re-use.sql
content_copyfile_download
--Static variable Example--
DECLARE @var1 VARCHAR(30)
SET @var1 = 'Generic Name'

SELECT * FROM TableName WHERE FieldName = @var1

--SAME Above Query can be written as below--
DECLARE @var1 VARCHAR(30) = 'Generic Name'

--Dynamic Variable Example--
DECLARE @var1 VARCHAR(30)
SET @var1 = (SELECT ColumnName FROM TableName WHERE FieldName = 'something')

SELECT * FROM TableName WHERE FieldName = @var1


--Some More data type examples--
DECLARE @iVariable INT = 1, @vVariable VARCHAR(100) = 'myvar', @dDateTime DATETIME = GETDATE()