INSERT EXEC statement cannot be nested, the Simple Solution

Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.

CLR Execution

CLR Inside Out: Writing Reliable .NET Code

When we talk about something being reliable, we're referring to it being dependable and predictable. When it comes to software, however, there are other key attributes that must also be present for the code to be considered reliable.