Post reply

Code libraries / includes in stored procedures

  • March 18, 2009 at 3:46 pm

    #129899

    Recently I wrote a bunch of stored procedures that use the same 25 lines of code and then go on their way to do what they were designed to do.

    Is there any functionality in stored procedures to include a chunk of code (library, include etc)?

    This would avoid having to copy the code multiple times and if I wanted to change it I could do it in one place rather then in each stored procedure.

    Thanks

    David Weil

  • March 18, 2009 at 3:55 pm

    #962315

    Hi

    I don't know any way to include code blocks. Maybe think about moving this code into a UDF or helper procedure.

    Greets

    Flo

  • March 18, 2009 at 5:15 pm

    #962353

    [font="Verdana"]You may be able to move some of the common code into their own stored procedures or functions.

    Failing that, have you considered using code templates?

    [/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply