560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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|
25 Aytoun Street