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 vote222 views1 answer
Mysql get hour from datetime
SQL
0 vote187 views3 answers
Get free card roblox
SQL
32 votes200 views6 answers
Sql count where
SQL
0 vote183 views2 answers
Sqlalchemy core in clause
SQL
94 votes414 views4 answers
Create database postgres
SQL
4 votes244 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
2 votes268 views1 answer
Creating a view SQL
SQL
1 vote192 views1 answer
Multiple count in sql
SQL
0 vote200 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote186 views1 answer
Update top 100 sql
SQL