SQL101-Homework Assignment #4

Here are some more practice problems.  This time you’re going to practice using DELETE. 1. Write a DELETE query that would remove a record from person.contact by contactID, pick a contactID that does not exist in person.contact. 2. Write a DELETE query that would remove a record from person.contact by first and last name. 3.… Continue reading SQL101-Homework Assignment #4

SQL 101 – DELETE

It looks like I’m getting close to the end of my 101 series.  After I show you how to remove data from tables, the last topic I plan to cover is creating tables.  It’s been quite a journey, collecting all this knowledge and putting it out there for you.  I had hoped to get some… Continue reading SQL 101 – DELETE

SQL 101 – TRANSACTION

As I mentioned in my previous post, before you move on to more difficult topics I need to share with you what a TRANSACTION is, and how to use them.  By now I’m sure you’ve seen t-SQL on tutorials.  The T stands for transactional.  If you don’t know what a TRANSACTION is, that’s pretty meaningless,… Continue reading SQL 101 – TRANSACTION