|
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.
Fezzik: Oh good, my way. Thank you Vizzini… what’s my way?
Vizzini: Pick up […]
“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 […]
In the previous post I mentioned the use of views to simplify querying your database in general and PowerPivot in particular.
What are Database Views?
Views are virtual tables, which you can create with a SQL statement. Some of the advantages of using views are:
Simplified Data Access – The view hides the data structure from […]
There’s a new independent M2M forum available called M2M Talk, which is free for everyone who works with M2M. It was started by a third party solutions provider who’s been working with Made2Manage customers a long time.
It’s been running roughly two months and some of the best people in M2M are on it. It […]
Vacationing at PASS?
In my previous article about paying my own way to PASS an anonymous commenter said he wouldn’t attend because he would have to take vacation to do so. Well, let me tell you it was just like a vacation for me.
First, by my own admission, I basically acted like a tourist. […]
|
|
Recent Comments