Query to Excel Stored Procedure
Transform your query result into an Excel file using this technique.
2018-03-05
3,103 reads
Darko Martinovic
2017-07-07
1,062 reads
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
2,778 reads
How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
2016-12-19
4,367 reads
Blogs
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
SQL Server 2019 on Docker no longer runs as root by default
In my home lab I have an Ubuntu virtual machine that runs both SQL...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
how to list index corresponding to statistics using select statement
Hi , with query bellow I can list DTA statistic that is not updated...
Get files based on SQL results
I have a sql task which queries a database and returns a result set...
Ask SSC