SQL server 2008 Question: Download Questions PDF
Tell me inline variable assignment in sql server 2008 with an example?
Answer:
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
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
Download SQL server 2008 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain Compound Operators in sql server 2008? | What is Declarative Management Framework (DMF) in SQL Server 2008? |