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 vote272 views1 answer
Sqlalchemy get schema from database
SQL
1 vote257 views1 answer
Add constraint sql
SQL
0 vote274 views1 answer
Sort by
SQL
20 votes293 views1 answer
Get all table name in sql through php
SQL
0 vote258 views1 answer
Not between mysql
SQL
0 vote278 views1 answer
Mysql workbench format date
SQL
3 votes279 views2 answers
Oracle privileges users
SQL
-1 vote253 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote250 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote258 views1 answer
How to create an SQL save method in ruby
SQL