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.

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

Posted by Andy Brown on 03 February 2017

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

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!

  1. My 5 favourite SQL system stored procedures! (this blog)
  2. Listing the contents of a procedure or function (sp_helptext)
  3. Using sp_datatype_info to get the data type of a variable
  4. Which tables/procedures depend on which? (sp_depends)
  5. Listing the columns in a table (sp_columns)
  6. Using sp_help to get help on a table, procedure, column, etc
This blog has 0 threads Add post