INSERT EXEC statement cannot be nested, the Simple Solution

Question

INSERT EXEC statement cannot be nested, the Simple Solution

Daniel Brink

Mr or Mrs. 500

Points: 506
More actions
August 19, 2022 at 12:00 am

#4077171

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

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

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

Eric Mamet SSChampion Points: 11722 More actions · Answer 1

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

Peter Heller SSC Eights! Points: 989 More actions · Answer 2

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, 8 months ago by Peter Heller. Reason: No rating which I would have given a 5

MMartin1 One Orange Chip Points: 27782 More actions · Answer 3

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.

----------------------------------------------------