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 vote93 views1 answer
Difference between cross apply and inner join
SQL
8 votes142 views1 answer
Racle create auto increment column
SQL
0 vote113 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote120 views1 answer
Get relation data in mysql using query to excel
SQL
25 votes123 views5 answers
Uninstall mysql ubuntu
SQL
36 votes115 views6 answers
Rename table sql
SQL
0 vote113 views1 answer
Create table like sql
SQL
1 vote113 views1 answer
What is a Database?
SQL
9 votes148 views1 answer
No sql
SQL
0 vote111 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL