INSERT EXEC statement cannot be nested, the Simple Solution

  • Comments posted to this topic are about the item INSERT EXEC statement cannot be nested, the Simple Solution

    Anything can be fixed

  • Really interesting.

    As you mentioned, if we need to setup some test data, we'll have to do that inside the code called by the CLR... AND remember to roll this back.

    As long as we bear this in mind, it looks brilliant.

    Many Thanks


  • This is a great proprietary solution but lacks portability in a heterogeneous database environment using ANSI SQL.

    You said "All those solutions are hacky, and it is simply not always possible to change the underlying code.".  How about converting the nested proc to inline block of code in the main proc.   It is a parallel to avoid using scalar functions for check constraints instead of inline.

    Great article!  I rate this a 5

    • This reply was modified 1 year, 10 months ago by  Peter Heller. Reason: No rating which I would have given a 5
  • A very nice and handy article. I learned about assemblies built with C# long ago but never got around to using them. This is an example of a good time to use them.


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

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