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 vote370 views1 answer
Mysql in clausule string array
SQL
0 vote394 views1 answer
Sql sum show 0 result
SQL
-1 vote345 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote394 views1 answer
MySQL update with subquery
SQL
0 vote387 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote356 views1 answer
Mysql monthname
SQL
0 vote366 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote383 views3 answers
Postgresql get difference between two dates
SQL
0 vote379 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote359 views1 answer
Oracle allow space to user
SQL