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 vote196 views1 answer
Login phpmyadmin without password
SQL
0 vote199 views1 answer
Soql last week
SQL
13 votes222 views2 answers
Sqlite rename table
SQL
0 vote213 views1 answer
Placements hackerrank solution
SQL
1 vote224 views1 answer
Check current sequence value postgres
SQL
0 vote200 views1 answer
Min and max salary and name in sql
SQL
10 votes217 views2 answers
SQL rounding numbers
SQL
0 vote232 views2 answers
Postgresql variable in query
SQL
3 votes223 views2 answers
How to force truncate a table in mysql
SQL
1 vote238 views1 answer
Oracle show execution plan
SQL