SQL 2008 - 2012 - Declare and Assign Variable in Single Statement

Vecchio metodo (dichiarare la variabile e poi settarla):

DECLARE @iVariable INT
DECLARE @vVariable VARCHAR(100)
DECLARE @dDateTime DATETIME

SET @iVariable = 1
SET @vVariable = 'myvar'
SET @dDateTime = GETDATE()

SELECT @iVariable iVar, @vVariable vVar, @dDateTime dDT

Oppure:

DECLARE @iVariable INT; SET @iVariable = 1
DECLARE @vVariable VARCHAR(100); SET @vVariable = 'myvar'
DECLARE @dDateTime DATETIME; SET @dDateTime = GETDATE()

SELECT @iVariable iVar, @vVariable vVar, @dDateTime dDT

Nuovo metodo (.NET-style):

DECLARE @iVariable INT = 1
DECLARE @vVariable VARCHAR(100) = 'myvar'
DECLARE @dDateTime DATETIME = GETDATE()

SELECT @iVariable iVar, @vVariable vVar, @dDateTime dDT

Trovato qui.