Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

TechTip: Simplify Stored Procedure Upgrades with Parameter Defaults

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • TechTip: Simplify Stored Procedure Upgrades with Parameter Defaults

    ** This thread discusses the article: TechTip: Simplify Stored Procedure Upgrades with Parameter Defaults **
    I experimented using this today and discovered a couple of things:
    1. My procedure source is set up to Create or Replace the procedure. If you add extra parameters and execute this the system creates a new procedure with the different signature. This can be avoided by specifying the specific name of the procedure (which is typically the same as the name of the procedure) using keyword specific after the external keyword section.
Working...
X