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

1 vote212 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote218 views2 answers
Mysql missin expression near on
SQL
0 vote214 views1 answer
Mysql custom sort order
SQL
0 vote203 views1 answer
Sql how to get courses that i have made prerequisites
SQL
1 vote211 views1 answer
Pl sql insert into table
SQL
0 vote206 views2 answers
How to install mssql on mac
SQL
2 votes224 views1 answer
Drop all foreign key constraints mysql
SQL
1 vote238 views1 answer
Homebrew install mysql
SQL
6 votes219 views2 answers
Oracle undotbs usage
SQL
0 vote194 views1 answer
Sql join on a subquery
SQL