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 vote319 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
2 votes338 views2 answers
Sql query to copy data from one column to another
SQL
11 votes374 views1 answer
Oracle insert from select
SQL
1 vote349 views1 answer
Print year of a date sql
SQL
0 vote303 views1 answer
Mysql max number not returning correct value
SQL
3 votes345 views1 answer
Postgresql today - 1 year
SQL
9 votes354 views2 answers
SELECT User,Host FROM mysql.user;
SQL
3 votes312 views3 answers
Sql current year
SQL
11 votes353 views2 answers
How to import mysql database command line
SQL
1 vote332 views1 answer
Window function mysql
SQL