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 six 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.
If you only remember one system stored procedure, this is probably the one to choose. Here are some examples of its use.
To get information about a specific table, use its name as your parameter:
-- get information on the table called DIRECTOR
Here's what this would show:
Lots of useful information here!
If you want to use a system (or your own) stored procedure, but can't quite remember what parameters it takes, try this:
-- what parameters does a procedure take?
This shows that this particular system stored procedure (sp_who) takes one parameter:
You must supply a single string to the procedure.
Use sp_help without any parameters to get a listing of everything in your database:
-- get a list of everything!
Here are the first few of the 2,283 rows returned for the Wise Owl Movies database:
The first few rows returned, out of many!
And that's the end of this blog!
|Parts of this blog|
25 Aytoun Street