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

19 votes344 views4 answers
Rename database in sql
SQL
1 vote492 views3 answers
Uninstall postgresql mac
SQL
1 vote330 views1 answer
Sql server 2016 reseed identity
SQL
31 votes338 views4 answers
How to get duplicate records with multiple field in sql
SQL
7 votes339 views1 answer
Safe update mysql
SQL
1 vote343 views4 answers
Aggregate function in sql
SQL
36 votes361 views6 answers
Rename table sql
SQL
0 vote421 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote352 views1 answer
Sqlcmd no headers
SQL
0 vote308 views1 answer
Count column of tables psql
SQL