Tag Archives: SQL201

SQL201 – Stored Procedure Results

by on 20110926 in Microsoft SQL

I’m working my way through the last of the 201 lessons. Today we’re going to dive back into stored procedures. This time I want to cover the three ways you can get data back out. You can simply use a SELECT statement to return a record set, or you can define one or more of [...]

 

Comments ( 0 )

SQL201-On Handling Errors

by on 20110922 in Microsoft SQL

    Let’s get back into SQL 200 by learning to deal with errors. Churchill had a great quote that applies to development (database or not) “He who fails to plan is planning to fail.” No matter how well you think you’ve planned your code, it’s going tofail.   The question is, will it fail [...]

 

Comments ( 1 )

SQL 201-Non-Correlated Sub Queries

by on 20110606 in Microsoft SQL

It’s been a while since I’ve covered any material for my SQL 201 series, so I thought I’d jump back into it with non-correlated sub queries.  It’s a mouthful.  But it’s a really simple concept, you can join two queries that have absolutely nothing to do with each other into one statement. I’d like you [...]

Comments ( 1 )
Older Entries »