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.

CREATE PROC #TempProc 

@Name nvarchar(50) 

AS

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: GeeksWithBlogs.net