How to insert results of stored procedure into a temporary table without creating the table first? Here is a simple script that shows the steps.
Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094
What is the fastest way to display code of any stored procedure? It is not always clicking Modify in SSMS. Here is the age old interview question and my answer.
Calling a REST API From T-SQL With sp_invoke_external_rest_endpoint
Use sp_invoke_external_rest_endpoint in SQL Server 2025 with controlled permissions, JSON responses, protected credentials, and retries.
SET NOCOUNT ON in SQL Server: How to Hide Rows Affected Messages
SET NOCOUNT ON stops SQL Server from sending a rows affected message after every statement. This post tests what it changes and what it doesn’t: @@ROWCOUNT, scope inside a procedure, timing and the text that sp_updatestats prints. It also covers client programs that depend on the count.
How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088
Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?
SQL SERVER – System Stored Procedures I Use to Get Started
System Stored Procedures remain part of my troubleshooting toolbox. I use these familiar entry points before moving to more detailed views.
List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070
In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.