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
17,135 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
7,063 reads
Blogs
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Creating a “Real” Copy of a View: #SQLNewBlogger
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
T-SQL Tuesday #181: A Technology Present
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
Forums
Query is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Script is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Date data type not recognized with oledb type provider
Hello, We recently made the following observation working with VS2022 combined with the SSIS...
Question of the Day
The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers