temp stored procs - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

temp stored procs

Author

Topic

xpandre
Posting Yak Master

212 Posts

Posted - 2003-11-26 : 07:58:24

Hi,
I was just going through few optimisation sites n i found this

Instead of using temporary stored procedures, you may want to consider using the SP_EXECUTESQL stored procedure instead. It provides the same benefits on temporary stored procedures, but it does not store data in the systems tables, avoiding the contention problems.

Can any one tell me what a temporary stored procedures is

thank you
Sam

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2003-11-26 : 08:10:29

It is just like any other temp object.
Sort of defeats the benefits of stored procedures though


create proc #up_tempproc
as
	set nocount on
	select 1 
GO

exec #up_tempproc
drop proc #up_tempproc
GO

There is info in BOL under Temporary Stored Procedures

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources