Stored procedure that deletes given SP

filipczako · December 2nd, 2005, 07:03 AM

is that possible in SQL...

jbenson001 · December 2nd, 2005, 02:53 PM

Not sure what you are asking?

filipczako · December 6th, 2005, 08:22 AM

Quote:

quote:Originally posted by jbenson001
Not sure what you are asking?

i am not sure too...:)
i give delete sp as parameter sp to delete. And this sp deletes that sp:)

jbenson001 · December 6th, 2005, 10:57 AM

Yes, you can do that.. but you will have to use dynacmic sql to do it.

filipczako · December 7th, 2005, 03:34 PM

Quote:

quote:Originally posted by jbenson001
Yes, you can do that.. but you will have to use dynacmic sql to do it.

so how ?

jbenson001 · December 7th, 2005, 04:25 PM

declare @sql nvarchar(500)
declare @proc nvarchar(100)
set @sql = 'Drop Procedure ' + @proc

EXEC sp_executesql @sql

You should check if the proc exists first so you don't get an error if it doesn't

Check books on line for more help.

Jim

filipczako · December 8th, 2005, 07:24 AM

Quote:

quote:Originally posted by jbenson001
declare @sql nvarchar(500)
declare @proc nvarchar(100)
set @sql = 'Drop Procedure ' + @proc

EXEC sp_executesql @sql

You should check if the proc exists first so you don't get an error if it doesn't

Check books on line for more help.

Jim

thx where can i get these books ?

jbenson001 · December 8th, 2005, 10:47 AM

Books On Line is the help for SQL Server, it should have been installed with the server installation.

filipczako · December 9th, 2005, 08:37 AM

Quote:

quote:Originally posted by jbenson001
Books On Line is the help for SQL Server, it should have been installed with the server installation.

with 2005 EE i dont have it:(