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 vote109 views1 answer
Cara menampilkan user di mysql terminal
SQL
4 votes121 views3 answers
Sql find second highest salary employee
SQL
16 votes126 views4 answers
Ascending order mysql
SQL
4 votes112 views2 answers
Linq join
SQL
0 vote141 views1 answer
How to remove quotes from a string in ssis load file
SQL
5 votes120 views1 answer
Postgres integer to serial
SQL
0 vote127 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote121 views1 answer
Apex ORA-20999
SQL
0 vote131 views1 answer
How to find lowest in sql
SQL
0 vote124 views1 answer
Ignore case in string sql
SQL