Post image

How to write a DELETE query

My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My First INSERT Statement My First UPDATE Statement This week is a much shorter post, where we will learn how to remove data from a table using a DELETE statement. We will also refresh our memories
-> Continue reading How to write a DELETE query

Post image

How to write an UPDATE query

My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This week we will learn how to make changes to data that is already in a table using an UPDATE statement. We are also going to learn all about why the WHERE clause is so important.
-> Continue reading How to write an UPDATE query

Post image

How to write a SELECT query

My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management Studio (SSMS) for instance, we can right-click on any table we have access to and select the top 1000 rows from that table. Please don’t query tables this way in a production environment. It’s a
-> Continue reading How to write a SELECT query