Deallocating variable in SQL Server
-
Hi All, I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server. So how i could achieve this? Thanks in advance, Rachit Damani.
-
Hi All, I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server. So how i could achieve this? Thanks in advance, Rachit Damani.
rachitdamani wrote:
I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server.
I don't understand what you mean by this. Why would you want to deallocate a variable?
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
-
Hi All, I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server. So how i could achieve this? Thanks in advance, Rachit Damani.
Can you explain this little bit more, if you want to just reinitializes various variables used in SP then use set statement with variable...
Regards, Jaiprakash M Bankolli jaiprakash.bankolli@gmail.com http://jaiprakash.blog.com/
-
Hi All, I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server. So how i could achieve this? Thanks in advance, Rachit Damani.
rachitdamani wrote:
I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server.
Will be automatically deallocated when it is out of scope
printf("Navaneeth!!") www.w3hearts.com