Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Local variable and global variables in SQL. [Resolved]
on 7/22/2013 |
| Views : 4303 | Status :
| Replies : 1
Write New Post
Un Answered Posts
What is the main different between local variable and global variables in SQL?
Reply with Attachment
SQL Server local variables are declared using the DECLARE statement, and exist for the duration of the batch in which they are declared.
They are declared with @ prefix.
SQL Server provides a massive number of global variables, which are very effective to use in our regular Transact-SQL. Global variables represent a special type of variable. The server always maintain the values of these variables. All the global variables represent information specific to the server or a current user session.
Global variable names begin with a @@ prefix. You do not need to declare them, since the server constantly maintains them. They are system-defined functions and you cannot declare them.
Mark as answer if satisfied.......
Kavya Shree M.
Kavya Shree Mandapalli
, if this helps please
Mark As Answer
Login to post response
How to close the respective modal dialog when switch over to other modal dialog without overlapping
how to save and use variable in jquery
How to add Parameterized Image in RDLC report?
How to Solve this Hosting Issues.
How do i get payment status in redirect page using bitpay?
What is autocomplete in input tag ?
How to pass parameters from html page to constructor of a class in C#
DropDownList Validation not working inside Gridview