Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a local and a global variable?
- 5 Answers
- 40433 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
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
explain extended properties
what are candidate key, alternate key and composite key? : Sql server database administration
Write a sql query to sort on different column name according to the parameters passed in the function?
How does a profiler work?
How to create dbo table in sql server?
What are the commands used in DCL?
What are the disadvantages of using querystrings to send data from one page to another?
What is the process of normalization?
Explain difference between cross join and full outer join?
What is sql stored procedure?
Do you know what is similarity and difference between truncate and delete in sql?
what is bit datatype? : Sql server database administration
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to enable/disable indexes?
