How to dertiminate

  • Thread starter Thread starter ad
  • Start date Start date
A

ad

I want to create a Stored Procedure with program.
If the Stored Procedure exist, I want to alter it.
How can I do that?
 
ad said:
I want to create a Stored Procedure with program.
If the Stored Procedure exist, I want to alter it.
How can I do that?
Click to expand...
To delete an stored procedur (only if exists):

IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[PROCEDURENAME]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[PROCEDURENAME]

To alter it:
ALTER PROCEDURE PROCEDURENAME.... (and then the new body for the procedure)

hope it helps...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to dertiminate if a sting in the keys of a hashtable 5
C# passes parameter but return value always -1 3
Call stored procedure in SSMS from Access 2016 doesn't work. 0
DataBase Refresh 1
Creating Stored Procedure 5
LINQ to XML: stored procedure returning result of FOR XML PATH 4
Stored Procedure fast in SSMS but times out in ADO.NET app 5
Security Questions 7

Back
Top