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';

Source: examplesql.com

Similar codes

0 vote255 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote255 views1 answer
Allow null in psql
SQL
2 votes250 views3 answers
Sql interview query questions
SQL
24 votes224 views5 answers
Sql reset auto increment
SQL
3 votes236 views1 answer
Sql is not like
SQL
0 vote235 views1 answer
How to get data between a last week in mysql
SQL
0 vote254 views1 answer
Sql out file formate
SQL
0 vote229 views1 answer
Oracle job schedules
SQL
0 vote244 views1 answer
TSQL convert csv to table
SQL
0 vote232 views1 answer
Psql check if value in array
SQL