What is the difference between a local and a global variable?
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
How column data types are determined in a view?
How connect excel to sql server?
How do I get to sql server configuration manager?
Explain the different types of backups available in sql server? : sql server database administration
How to receive output values from stored procedures?
How you provide security to cube? : sql server analysis services, ssas
What are policy management terms?
Why normalization is used?
What are the benefits of filtered indexes?
When does a workload on SQL Azure get throttled?
What types of replication are supported in sql server?
What is for xml in sql server?
what are the different ways to return the rowcount of a table?
How to make remote connection in database?
What are 3 ways to get a count of the number of records in a table?