SQL201

SQL201

SQL201 – Stored Procedure Results

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

SQL201

SQL201-On Handling Errors

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

sql

SQL 201-Non-Correlated Sub Queries

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.

SQL201

SQL Homework—UNION, INTERSECT, EXCEPT—Solutions

Here are the solutions to the homework problems I sent out.  Compare my queries with yours.  If they’re different, and you’d like some explanation on

SQL201

SQL Homework–UNION, INTERSECT, EXCEPT

This homework will run from my training server, shaioshin.hopto.org.  If you do not currently have access to this server, please let me know and I’ll set

SQL201

SQL201-The Syllabus

It’s that time again! Time to start up a new class and cover some more advanced topics in SQL Development. Before beginning these lessons, You need to be

microsoft sql

Converting VARCHAR to DATETIME

Recently a post was made on LinkedIn asking how one would convert a date stored in a VARCHAR field could be converted to a DATETIME so date math could be

SQL201

UNION, INTERSECT, and EXCEPT

Earlier today I was discussing methods you can use to differences in data sets between two tables or views. My colleague was discussing the usual

SQL201

Find Stored Procedures Referencing…

Time and time again, I find myself trying to find all the stored procedures that reference a specific database object. It usually comes around when I'm working

sql202

SET IDENTITY_INSERT

Let's say you have the following table on two servers, one in development and one in production. CREATE TABLE person ( personID INT IDENTITY(1,1) , firstName

t-sql

Code to Write Code

I've read "When you start writing code that writes code for you, you've moved up from a beginner to a professional." Today I'd like to walk you through an

t-sql

Get Rid of the Duplicate Records

Time after time I'll get a table that has duplicates in it and I have to clear out all the duplicate entries while leaving a distinct set of records. There's a