Writing Queries in SQL Server

Video Transcript

"Hi, my name is Dave Andrews. Today I'm going to to show you how to write queries in SQL Server. Let's open up the Management Studio. I already have mine open, and connected to the data base. What we're going to do is create a new query, on the table, People. So, right click on it, say Open Table. Now that the table is open, let's right click down here, on this tool bar, somewhere, and select Pane, and Type, and select the SQL option. This shows you the SQL that is being run in this query. Let's say we only want to see the Person name values that are in this table. Just erase the star, say Select Person Name, which is a field in the table from People. Let's click this little exclamation point to execute our SQL. Down at the bottom, you'll see, that only the Person name has been selected out of the table. It's that easy to write queries in SQL server. My name is Dave Andrews, and I've just showed you how to write queries in Microsoft SQL server."