Stored Procedure: alter if exist, create if not exist in one script

Viewed 27

As the title goes, how can I create a stored procedure if not already exist, and alter if already existed please?

As of now, I need to constantly delete and retype either alter/create keyword during development. I need to re-create because sometimes the change require me to drop the proc, other times I just need an ALTER statement.

Any help is much appreicated!

0 Answers
Related