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

16 votes100 views2 answers
Add column to all tables after first column mysql
SQL
3 votes97 views2 answers
Laravel tosql with bindings
SQL
0 vote104 views1 answer
OFFSET consulta mysql
SQL
0 vote116 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote102 views1 answer
ALV GRID events
SQL
0 vote102 views1 answer
Oracle grant create job
SQL
2 votes121 views1 answer
Show max_allowed_packet mysql
SQL
0 vote96 views1 answer
MySql Modify Increment
SQL
0 vote123 views1 answer
Declaring variables in pl sql
SQL
0 vote101 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL