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 vote218 views1 answer
Get the next column of a table in mysql
SQL
0 vote201 views1 answer
Postgres set default schema
SQL
4 votes159 views2 answers
Select todays data postgres query
SQL
0 vote196 views1 answer
Sum values by month mariadb
SQL
0 vote196 views1 answer
Inserted row count tsql
SQL
-1 vote190 views1 answer
Mysql coalesce
SQL
1 vote178 views1 answer
Reutrn string after character sql
SQL
52 votes323 views6 answers
Rename column sql
SQL
0 vote218 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote225 views1 answer
Mysql previous year
SQL