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

23 votes358 views1 answer
How remove column in mysql
SQL
0 vote365 views1 answer
How to query without duplicate rows in sql
SQL
0 vote364 views1 answer
Add a new column into table
SQL
0 vote723 views1 answer
Sql field equals multiple values
SQL
-1 vote342 views1 answer
Sql add column bit
SQL
11 votes356 views1 answer
Oracle view ddl
SQL
6 votes357 views2 answers
Database url postgres
SQL
0 vote353 views1 answer
Mysql persistence.xml
SQL
7 votes366 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote346 views1 answer
Postgres first_value in gropby
SQL