Query to Excel Stored Procedure
Transform your query result into an Excel file using this technique.
2018-03-05
7,628 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,137 reads
How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
2016-12-19
14,788 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers