This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

A list of one owl's 5 favourite system stored procedures in SQL! Part one of a six-part series of blogs
Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway. My 5 favourite SQL system stored procedures! (this blog) Listing the contents of a procedure or function (sp_helptext) Using sp_datatype_info to get the data type of a variable Which tables/procedures depend on which? (sp_depends) Listing the columns in a table (sp_columns) Using sp_help to get help on a table, procedure, column, etc

A list of one owl's 5 favourite system stored procedures in SQL!

Part one of a six-part series of blogs

Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway.

Posted by Andy Brown on 03 February 2017

My 5 favourite SQL system stored procedures!

Ok, so this is a bit of a sad list. After all, who has a favourite system stored procedure? I do, as it turns out. In fact, I've got 5 of them:

Number	Procedure	What it does
1	sp_helptext	Returns the lines for any procedure or function
2	sp_datatype_info	Returns information about SQL data types
3	sp_depends	Shows what any table depends on and/or is used by
4	sp_columns	Lists out the columns for a given table
5	sp_help	Lists out information on tables, procedures or everything!

Read on to see if you agree!

Parts of this blog
My 5 favourite SQL system stored procedures! (this blog) Listing the contents of a procedure or function (sp_helptext) Using sp_datatype_info to get the data type of a variable Which tables/procedures depend on which? (sp_depends) Listing the columns in a table (sp_columns) Using sp_help to get help on a table, procedure, column, etc