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

5 votes147 views4 answers
Upload database mysql command line
SQL
0 vote216 views1 answer
Mssql unique key accept nulls
SQL
0 vote127 views1 answer
Sql fetch next 10 rows pdo
SQL
13 votes185 views3 answers
Mysqldump structure only
SQL
5 votes142 views3 answers
Mysql remove unique constraint
SQL
0 vote139 views1 answer
Sql server select top 2 of each group
SQL
9 votes129 views2 answers
Default number in sql
SQL
0 vote180 views1 answer
Postgresql find biggest table
SQL
0 vote163 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote129 views1 answer
INSERT INTO table using OpenQuery
SQL