T-SQL

Variables

Scalar Variables

declaring

DECLARE @myVariable [TYPE]

e.g.:
DECLARE @myPersonalId INT
DECLARE @dateFrom DATETIME

Initializing

SET @myVariable = [value]

e.g.
SET @myPersonalId = 853
SET @dateFrom = CAST('2014-06-22 03:00:00.000' AS DATETIME)

List Variables

declaring

DECLARE @myList TABLE (myColumn [TYPE])

e.g.:
DECLARE @personalIds TABLE (Value INT)

Initializing

INSERT INTO @myList VALUES ([values])

e.g.

INSERT INTO @personalIds VALUES (123, 456)