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 vote221 views1 answer
Split string by comma in sql server
SQL
2 votes237 views2 answers
Install postgresql
SQL
1 vote224 views1 answer
Psql connections
SQL
3 votes236 views2 answers
Oracle sql select all days between two dates except weekends
SQL
1 vote242 views1 answer
Mysql text to decimal
SQL
0 vote223 views1 answer
Get records in sql according to month name and count
SQL
1 vote188 views1 answer
Ms sql how to see active job current run time
SQL
5 votes228 views1 answer
Sysdate in oracle sql
SQL
0 vote228 views1 answer
Sql order by number not ordered
SQL
9 votes231 views1 answer
Oracle get table schema
SQL