Geeks With Blogs
AzamSharp Some day I will know everything. I hope that day never comes.
Just like temporary tables in SQL SERVER 2000 you can also create temporary stored procedures.


@Name nvarchar(50) 


SELECT * FROM tblPerson WHERE Name = @Name 

DROP PROC #TempProc 

All Temp stuff is created under tempdb..sysobjects
SELECT * FROM tempdb..sysobjects will return you #TempProc
Posted on Saturday, August 20, 2005 11:27 AM | Back to top

Comments on this post: Creating Temporary SPROCS

# re: Creating Temporary SPROCS
Requesting Gravatar...
What is Sproc for? is it different anyway from procedures noramally used?
Left by Maestro on Sep 12, 2005 9:18 AM

Your comment:
 (will show your gravatar)

Copyright © Mohammad Azam | Powered by: