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
Why use “in” clause in sql server?
Explain what is the main purpose of having conversation group?
Is there any difference between the primary key and unique key?
Explain indexing and what are the advantages of it?
What is sql injection and why is it a problem? : sql server security
What are trace flags and mention a few common trace flags used with sql server?
How to create a large table with random data for index testing in ms sql server?
Explain system rowset functions?
What is normalization? Explain different forms of normalization?
what is the difference between delete table and truncate table commands? : Sql server database administration
what are acid properties? : Sql server database administration
What is the difference RDBMS and Graph Database?
What are the advantages of using stored procedures in sql server?
Comment,Datatypes are unlimited
How many types of schemas are there?