Answers

Question and Answer:

  Home  SQL server 2008

⟩ Tell me inline variable assignment in sql server 2008 with an example?

Inline variable assignment in SQL Server 2008 enables to – declare, and assign the variables in a ‘single line’.

The traditional Ex:

DECLARE @myVar int

SET @myVar = 5

need to declare the variable and assigning it to the variable to split into 2 lines and use 2 statements - DECLARE and SET.

In SQL Server 2008, as the name suggests ‘inline’, both declaration and assignment can be given in a single line:

DECLARE @myVar int = 5

 147 views

More Questions for you: