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

1 vote278 views1 answer
Sql get missing id
SQL
12 votes326 views6 answers
Distinct in sql server
SQL
1 vote276 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote316 views2 answers
Mysql update two tables at once
SQL
0 vote320 views1 answer
Mysql date without time
SQL
3 votes289 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote289 views2 answers
Getting customers with no orders sql
SQL
0 vote310 views1 answer
Dbms_output sql developer
SQL
1 vote317 views2 answers
Mysql extract number from string
SQL
0 vote272 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL