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

10 votes134 views1 answer
Oracle object dependencies
SQL
0 vote151 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
7 votes142 views3 answers
Sql set
SQL
1 vote147 views1 answer
Convert to hexadecimal sql
SQL
0 vote167 views1 answer
Dynamic where clause in sql server stored procedure
SQL
3 votes222 views1 answer
Ssh check mysql version
SQL
1 vote129 views1 answer
Too many connections mysql
SQL
0 vote160 views1 answer
Inner join distinct
SQL
1 vote124 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote133 views1 answer
Python sql last insertend
SQL