|
||||||
|
It’s been a crazy few weeks. As I mentioned previously, I presented at two SQL Saturday Events in back to back weeks. I’m on the core committee for the North Texas SQL Server User Group SQL Saturday, so I was overwhelmed with things to do and couldn’t stop to blog. So, now that I’ve taken […] I’ll be presenting at two SQL Saturdays back to back. You are taking advantage of SQL Saturday events, right? SQL Saturday Chicago is this weekend (3/26), and I’ll be presenting: Data Warehousing – How to Convince “The Bobs” I got a meeting with the Bobs in a couple of minutes… Building your first Data Warehouse […] “Melodical Murray is a human musical instrument; he makes music by blowing his…blank” – Match Game In the previous article I discussed the issues when working with Null-able fields in Joins and Where clauses. This article will deal with the problems of blank values. What About Blanks? Many systems forego the use of Null-able fields, but […] This topic has been done to death in many places, but I still get frequent questions about Null field issues in T-SQL. My purpose in this article is not to debate the definition of Null. Smarter men than I have already done so. SQL Server Books Online indicates “A value of NULL indicates that the […] 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 […] 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? Tweet 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 […] |
||||||
|
Copyright © 2021 Made2Mentor - All Rights Reserved |
||||||
Recent Comments