|
||||||
|
|
In this seventh article of the T-SQL Basics Series, we will be covering both the basics as well as some specific issues with SQL Joins. If you’ll recall our last lesson, we wrote a sales query for Master Po. He then requested that we add customer information to the report. Note, after receiving e-mails from [...] Today Grasshopper, I will teach you the basics of ordering, summarizing, and grouping your data to give it meaning. Let’s say that the Kung Fu Temple Gift Shop has had poor sales. Master Po wants a list of sales details from you, but he wants them ordered by the part number. Note for the non [...] Pick Me Mr. Kotter! SQL Rally is a brand new event for this year. It’s kind of a hybrid between the PASS Summit and a SQL Saturday. It’s fairly low cost and being held May 11-13 in Orlando, Florida. Anyway, the reason for this post is completely self serving. I really want to present at [...] All of the queries we’ve looked at so far will return all of the records in a table. This isn’t very efficient. The Where clause filters records out of your result set that you do not want. For example, suppose we’re only interested in Sales Order Master records for “Acme Rockets Inc.” The following select [...] I mentioned in my last article that I would be posting a video showing you the basics of working with Toad for SQL Server. What do you think of my first effort? As I mentioned in the last article, you need to develop or adopt a standardized way of writing T-SQL code. In this article, I’m going to share the habits I’ve developed, “my way” if you will. Vizzini: Finish him. Finish him, your way. “First learn stand, then learn fly. Nature rule, Daniel-san, not mine.” – Karate Kid What is SQL? SQL (Structured Query Language) is a language for manipulating database data and structure. It can be pronounced by stating it’s letters “S-Q-L” as well as the word “sequel”, as in the Matrix had two crappy sequels. SQL is mostly [...] I wish I knew how to quit you… Well, not really. In previous articles, I’ve mentioned that I use Toad for SQL Server, but until now I have not really advocated that my readers use it. While I’ve been using Toad for several years, I’ve had a love/hate relationship with it. When I first started [...] In my previous article I mentioned my surprise that many readers were not running the sample code posted on my blog. When I asked a few as to why, the number one answer was that some M2M Admins don’t know which program(s) they can use to query their SQL databases. I don’t know why this [...] Over the holidays and through the first week of this year, I took a journey back home to Michigan. Why did I drive you ask? Well, I wanted to take my Cockatoo Anakin with me. Sometime along the trip he decided that migrating was for the birds. We survived, but he was thrilled after we [...] |
|||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles