Skip to content

shannonlowder.com

Menu
  • About
  • Biml Interrogator Demo
  • Latest Posts
Menu

Tag: SQL201

SQL201 – Stored Procedure Results

Posted on September 26, 2011 by slowder

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…

Continue reading

SQL201-On Handling Errors

Posted on September 22, 2011September 22, 2011 by slowder

  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 gracefully,…

Continue reading

SQL 201-Non-Correlated Sub Queries

Posted on June 6, 2011 by slowder

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…

Continue reading

SQL Homework—UNION, INTERSECT, EXCEPT—Solutions

Posted on March 23, 2011January 26, 2012 by slowder

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 why they’re different.  Let me know.  I’ll be happy to explain any differences with you. 1. Give me a list of all the first and last names in both tables. …

Continue reading

SQL Homework–UNION, INTERSECT, EXCEPT

Posted on March 21, 2011January 26, 2012 by slowder

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 up credentials so you can complete the following homework assignment. In the AdventureWorks database on my server I have two tables: example.person and person.contact.  Take a look at the…

Continue reading

SQL201-The Syllabus

Posted on March 14, 2011August 19, 2013 by slowder

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 comfortable with all the material in my SQL101 series. Specifically you’re going to need to know SELECT, INSERT, UPDATE, and DELETE. With those skills in hand, I’ll…

Continue reading

Converting VARCHAR to DATETIME

Posted on March 28, 2010February 9, 2011 by slowder

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 performed.  Unfortunately, this problem is more common than it should be.  If users are given a free-form field to enter data, they’ll often enter unreliable…

Continue reading

UNION, INTERSECT, and EXCEPT

Posted on March 19, 2010March 21, 2012 by slowder

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 method SELECT columName(s) FROM table1 t1 (READCOMMITTED) LEFT JOIN table2 (READCOMMITTED) ON t1.sharedKey = t2.sharedKey WHERE t2.sharedKey IS NULL While this is a perfectly cromulent way of finding out what…

Continue reading

SQL 201-Formatting Dates in Microsoft SQL

Posted on March 15, 2010April 12, 2011 by slowder

One of the more frequent questions I get for SQL Server is how to format a DATETIME into a specific date format. Here’s a summary of the different date formats that come standard in SQL Server as part of the CONVERT function. Following the standard date formats are some extended date formats that are often…

Continue reading

Find Stored Procedures Referencing…

Posted on July 17, 2009November 16, 2011 by slowder

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 on changes to a table’s structure, or I’m replacing a table with a view.  I’ll usually reach for the following query (or something like it. 1: SELECT ROUTINE_NAME…

Continue reading
  • 1
  • 2
  • 3
  • 4
  • …
  • 6
  • Next
  • Career Development
  • Data Engineering
  • Data Science
  • Infrastructure
  • Microsoft SQL
  • Modern Data Estate
  • Personal
  • Random Technology
© 2023 shannonlowder.com | Powered by Minimalist Blog WordPress Theme