• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 810
  • Last Modified:

Usng Sybase Adaptive Server Enterprise 15.5, to modify an existing Stored Procedure what statement do I use? In SQL Sever, I use ALTER PROCEDURE?

Usng Sybase Adaptive Server Enterprise 15.5, to modify an existing Stored Procedure what statement do I use?

In SQL Sever, I use ALTER PROCEDURE [stored procedure name]
0
zimmer9
Asked:
zimmer9
1 Solution
 
PortletPaulfreelancerCommented:
Alter Procedure isn't supported in ASE

try this  instead:

if exists(select 1 from sysobjects where name = 'NameOfProc' and user_name(uid) = 'dbo')
begin
  drop procedure NameOfProc
END
go
create procedure dbo.NameOfProc(@whatever ....
as ....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now