BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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
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!
- 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