<< Returning Friendly Message Instead of NULL Using T-SQL Query | Home | Preventing Users to go back to the previous pages. >>

Creating Temporary SPROCS

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

Print | posted @ Saturday, August 20, 2005 11:27 AM

Twitter