Does v9 support both "ALTER" & "If exists .. DROP + CREATE"?

• 
  I have run into this issue on numerous occasions. We have functions that call themselves recursively. If you add a parameter to the function that calls itself, simply doing an alter function will not work because it will give you an error that "the procedure or function has too many arguments specified".
  
  If you drop and create the function, it will create it properly.

  Barry K October 27, 2011 11:47

  - 0 +
• 
  The latest 9.5 Beta has options to add existence checks and DROP/CREATE.
  
  More details here:
  http://www.red-gate.com/MessageBoard/vi ... hp?t=14113
  
  Please give it a go and let us know if this meets your requirements.
  
  David Atkinson
  Product Manager
  Red Gate Software

  David Atkinson October 27, 2011 11:53

  - 0 +
• 
  The latest 9.5 Beta has options to add existence checks and DROP/CREATE.
  
  More details here:
  http://www.red-gate.com/MessageBoard/vi ... hp?t=14113
  
  Please give it a go and let us know if this meets your requirements.
  
  David Atkinson
  Product Manager
  Red Gate Software

  David Atkinson October 27, 2011 11:53

  - 0 +

Add comment

Please sign in to leave a comment.