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.

Returning Info from Stored Procedures

Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code

In this tip we look at different scripts you can use to find when a SQL Server stored procedure was created, modified, last executed and to also return the code for the stored procedure.