Tag Archives: SQL procedures

How to Execute SQL Procedure in Excel incl. Parameters with Example

I must say right from the beginning that even though this process is possible, I do not recommend it (but I will show it to you anyway) :). Launching SQL queries in Excel is not optimal in general, but sometimes there is no other option. This guide is aimed on advanced Excel users with SQL… Read More »

Top 10 Most Useful MS SQL System Stored Procedures

System stored procedures are useful administrative tools. Below, you may find 10 of them which I consider as the most useful: sp_help – info on objects in database, data types sp_spaceused – displays space on the disk allocated to database and storage for each database objects including number of rows in the table sp_who – returns… Read More »