556 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 four 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.
This is so useful that I wish I'd known it before. You can use it in one of two main ways.
Suppose you have a table called Film, and you want to see what views, procedures, etc refer to it. Here's how to do this:
-- what uses the films table
It turns out there are two procedures and a view referencing this table:
The list of objects which depend on the specified table.
Turning the question round, here's how to show which tables and columns a particular stored procedure references:
-- what does the spExample procedure use
Here's the answer for this procedure:
The three columns referenced by this procedure.
It even tells you if the procedure makes changes to a column!
|Parts of this blog|
25 Aytoun Street