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
28,756 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)
25,517 reads
Blogs
Using Git Prune–#SQLNewBlogger
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
Microsoft Purview new data governance features
By James Serra
Starting last week is a rollout of the public preview of a new and...
SQL Database Administration: Not For Everyone (But Maybe It’s for You)
Let's get one thing straight: database administration isn't the most glamorous tech job out...
Forums
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Create Copy of DB in same server.
Hi I want to create a copy of a DB on the same server....
Question of the Day
Restoring the Resource Database
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers