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 vote175 views2 answers
Sql last updated
SQL
0 vote180 views1 answer
Commit transaction sql
SQL
0 vote189 views1 answer
Alter database name script
SQL
0 vote186 views1 answer
Sql server list user permissions
SQL
4 votes181 views1 answer
Mysql copy table with new name
SQL
1 vote186 views2 answers
Test sqlsrv connection
SQL
0 vote184 views1 answer
What is the difference between now() and current_date()?
SQL
3 votes175 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote196 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote169 views1 answer
Encrypt password postgresql
SQL