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 vote167 views1 answer
Including parameters in OPENQUERY
SQL
4 votes140 views2 answers
Mysql select where starts with
SQL
0 vote199 views1 answer
Show mysql account privilleges
SQL
0 vote150 views2 answers
Connect to mysql server mac terminal
SQL
0 vote160 views1 answer
Safe mysql
SQL
2 votes157 views1 answer
Sql get the name of user pc
SQL
1 vote138 views1 answer
Drop table if exists oracle
SQL
3 votes144 views2 answers
Oracle for loop
SQL
0 vote157 views1 answer
Data types mysql vs postgresql
SQL
2 votes144 views1 answer
How to check if a row is null in sql
SQL