Archives

T-SQL Basics - Filtering Records with the Where Clause

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 [...]

How to Code with Toad

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