April 19, 2005 at 9:02 am
I seem to remember something about SQL Server storing previous versions of stored procs as myProcName;-1 or something like that. Is the text of the previous versions available, and if so, how?
Thanks,
Larry
Larry
April 19, 2005 at 9:20 am
I've seen something similar, but it's something you have to do yourself... try this :
create Proc A;1 @Param as int
as
set nocount on
select @Param
set nocount off
GO
create Proc A;2 @Param as int
as
set nocount on
select @Param * 10
set nocount off
GO
exec A;1 10
--10
exec A;2 10
-100
drop proc A
exec A;2 10
--proc not found
April 19, 2005 at 1:53 pm
As Remi shows, this way of naming procedures can be used to group them together and drop them all with one DROP-statement. However it is not used by SQL Server for automatically versioning procs, or in any other automatic way.
April 19, 2005 at 2:03 pm
But it is a nice way to create a few version of the same proc and see which one performs the best.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply