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

36 votes291 views3 answers
Finding duplicate column values in table with sql
SQL
2 votes290 views1 answer
How to find constraints on a table in oracle
SQL
0 vote279 views2 answers
Mysql to python pandas
SQL
1 vote263 views1 answer
Truncate table in postgresql and reset id
SQL
2 votes303 views1 answer
Postgresql update sequence next value
SQL
0 vote295 views1 answer
Mysql root permission denied lost
SQL
0 vote279 views1 answer
Power query case when
SQL
1 vote296 views1 answer
Mysql decimal allow negative values?
SQL
0 vote297 views1 answer
Mariadb current date plus 1 day
SQL
0 vote289 views1 answer
Synapse sql table set pk
SQL