There are many ways to know SQL Server version, but did you know two system procedures, sp_server_info and xp_msver, also return it?
SQL SERVER – What are the Different Ways to Script Procedure with T-SQL
What are the different ways to script procedure code with T-SQL? There are four, including sp_helptext and INFORMATION_SCHEMA.ROUTINES. Here is each one.
Refactoring Old T-SQL One Procedure at a Time
Begin refactoring old T-SQL with one procedure, repeatable inputs, duplicate-aware result checks, measured reads, and a simple change log.
SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10
Want to plot your own values, like rows in a table, next to standard PerfMon counters? The procedures sp_user_counter1 to sp_user_counter10 do just that.
Natively Compiled Procedures: ATOMIC Blocks and T-SQL Limits
Native procedures check every statement when you create them. Build a tiny one and see which habits it will not accept.
Unambiguous Date Literals: When 2026-04-03 Becomes March 4
A dashed date can change its mind with one session setting. Here is how to write dates that never do.
MySQL – How to Create Stored Procedure in MySQL
MySQL supports stored procedures for your business logic. Here is how to create a stored procedure in MySQL and execute it, with a simple sales example.