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 vote145 views1 answer
Table or view does not exist
SQL
0 vote172 views1 answer
Transaction and commit trong sql server
SQL
0 vote158 views1 answer
Query by column for substring sql
SQL
11 votes157 views6 answers
Distinct sql
SQL
0 vote158 views1 answer
Print orcale
SQL
-1 vote173 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote149 views1 answer
Neo4j display all nodes and relationships
SQL
2 votes146 views1 answer
Oracle sql concatenate results into string
SQL
0 vote146 views1 answer
Convert rows to columns in sql server
SQL
0 vote158 views1 answer
Mysql random number between 1 and 100
SQL