How to save results of a procedure with more than one result set
Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables
2012-09-06
13,120 reads
Pavel Sinkevich
How to create a CLR assembly on a remote server with limited permissions
How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available
2011-07-25
4,731 reads
Blogs
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
Forums
Migrating from 2008/2012 SQLserver to new server with sqlserver2019
Anyone have a guide on how I migrate SSIS from sqlserver 2008 / 2012...
sp_execute and sp_executesql and sp_prepexec for the same statement
From our software provided by a third party vendor, I am seeing the following:...
"Home PC" SQL instance
This may be a bit non-typical, but I am currently running SQL 2019 Developer...
Ask SSC