562 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 three 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.
Unless you have committed all of the SQL data types to memory, there'll be times when you want to remind yourself of how big an int really is, or what a varchar is and does. Here's how to get an answer! You can either get a full list:
-- show all data types
This gives the following:
There are many more columns and rows than are shown here.
Or you could be more specific:
-- show info on subset of data types
This would show you a rather odd subset of data types:
Again, there are more columns than are shown here!
Quite why nvarchar and date belong in the same group, but varchar doesn't, I'm not sure!
|Parts of this blog|
25 Aytoun Street