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.
2022-08-19
24,313 reads
SQLCLR
Build SQL Server CLR Triggers
In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
2022-02-21
Stairway to SQLCLR Level 2: Sample Stored Procedure and Function
In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.
2020-07-09 (first published: 2019-09-24)
24,987 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
SQL Window Functions Series: LAG() and LEAD()
Comments posted to this topic are about the item SQL Window Functions Series: LAG()...
Breaking Biometrics
Comments posted to this topic are about the item Breaking Biometrics
Attaching Databases
Comments posted to this topic are about the item Attaching Databases
Ask SSC