Bad Stored Procedures

Stored procedures can be poorly written, but Steve prefers them over embedded code.

SQL Server Temporary Stored Procedures

Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.

Parameter Defaults

SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more

In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure.

Playing popular game of Wordle using T-SQL

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

Playing popular game of Wordle using T-SQL

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

SQL Server RETURN and OUTPUT Clause in Stored Procedures

In this article we look how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.

Output Parameters

Using SQL Server Profiler to Capture Stored Procedures Executions

In this article we look at how to capture stored procedure executions using Profiler to help with troubleshooting issues that are occurring from your application making procedure calls.

The Developer Arguments for Stored Procedures

Today Steve asks what reasons a developer has for using stored procedures.