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 vote1.1K views1 answer
Mysql custom sort order
SQL
0 vote340 views1 answer
Mysql multiple primary keys
SQL
2 votes346 views2 answers
Sql query to copy data from one column to another
SQL
0 vote313 views1 answer
Myswql show full processlist
SQL
0 vote315 views1 answer
Restore backup "text" postgresql command line
SQL
4 votes341 views2 answers
Postgresql default value
SQL
1 vote342 views3 answers
Connection string mysql
SQL
0 vote320 views1 answer
Mysql identified by syntax error
SQL
1 vote376 views1 answer
Encrypt password postgresql
SQL
5 votes391 views1 answer
Oracle drop index if exists
SQL