sql declare set same line code example
Example: sql declare variable single line
-- Old clunky way of doing things prior to SQL Server 2008
DECLARE @myVar VARCHAR(100);
SET @myVar = 'Some Value';
-- New, amazing way of declaring variables
DECLARE @myVar VARCHAR(100) = 'Some Value';