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 vote290 views1 answer
Apache Derby: Create SQL Dump with data
SQL
1 vote266 views1 answer
Sample in sql
SQL
0 vote317 views1 answer
How to get button for every record from mysql
SQL
13 votes306 views4 answers
Mysql remove foreign key constraint
SQL
1 vote283 views1 answer
Simple project for database
SQL
1 vote288 views1 answer
Mysql check string don't have number
SQL
0 vote306 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote284 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote285 views1 answer
Mysql DDL
SQL
5 votes272 views1 answer
How to check port number for postgresql
SQL