SQL Server Table-Valued Parameter Join Issues in Stored Procedures
Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.
2026-05-06
Stored Procedures
Return stored procedure parameter values to a calling stored procedure
In a previous topic we discussed how to pass parameters into a stored procedure, but another option is to pass parameter values back out from a stored procedure. One option for this may be that you call another stored procedure that does not return any data, but returns parameter values to be used by the calling stored procedure.
2025-05-02
2024-11-22
477 reads
Bad Stored Procedures
Stored procedures can be poorly written, but Steve prefers them over embedded code.
2024-09-20
436 reads
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.
2024-05-27
2023-12-21 (first published: 2023-12-20)
499 reads
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.
2022-10-28
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.
2022-01-19
726 reads
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.
2022-01-19
4,563 reads
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.
2021-12-01
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers