What is the difference between a local and a global variable?
- 5 Answers
- 39305 Views
- I also Faced
- E-Mail Answers
Answer Posted / thiyagaraj.ramaswamy
Local Variable :
The scope or lifetime of the local variable
is with in a block or procedure..
Eg: DECLARE @Variable1
Global Variable :
The scope or lifetime of the global
variable throughout the execution of the program..
Eg: DECLARE @@Variable1
| Is This Answer Correct ? | 119 Yes | 23 No |
Post New Answer View All Answers
what stored procedure can you use to display the current processes? : Sql server administration
What are indexes in sql?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Difference between LEN() and DATALENGTH() in sql server ?
Name some of the open source software that you can use in alternative to SSR?
A trigger can reference objects outside the current database? State true or false.
Tell me about pre-defined functions of sql?
Is it possible to update the views? If yes, how, if not, why?
How to get the definition of a trigger back?
Can you pass expressions to stored procedure parameters?
How to provide values to user defined function parameters?
Explain the difference between functions and stored procedures in sql server?
what is normalization? : Sql server database administration
If any stored procedure is encrypted, then can we see its definition in activity monitor?
how you can get the list of largest tables in a database? : Sql server administration
