Query to Excel Stored Procedure
Transform your query result into an Excel file using this technique.
2018-03-05
7,564 reads
Darko Martinovic
Practical usage of SQLCLR: Building QueryToHtml function
This article shows a few techniques with SQLCLR to to transform a query result into HTML.
2017-06-05
4,098 reads
How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
2016-12-19
14,565 reads
Blogs
Using Customer Docker Compose File Names
By Steve Jones
As I use containers more and more to run various things, I decided I...
SQL Server Failover Cluster Instances
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Forums
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
Handling Engagement Rings & Wedding Band
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers