Using the Query Builder in SQL Server

Video Transcript

"Hi, my name is Dave Andrews. Today, I'm going to show you how to use the query builder in SQL Server. Let's open up the Management Studio. I have mine already connected to a SQL Server. As you can see, I have the database and my database, and a table called People. What we're going to do is click on New Database, and we're going to say up here New Query. This opens up the query that we're going to run. What we're going to click up here at the very top is this little protractor and pencil, and we're going to say Design Query in Editor. Now, this brings up the query designer. Let's select the People table, say add, and then click on close. Here, we have our tables that we're going to include in our query, as well as the columns we've selected. Let's check on the person name to include him in what we're going to include in our query. As you can see, it's added select person name down here at the bottom. We can do things like sorting by ascending, as well as adding filters to where we would only select certain data from the table. But now that we have our query built at the bottom, just say okay. This is our new Microsoft SQL query, and we're going to execute it. As you can see, for my query, I've gotten an error message. This is because I selected sorting on a text field. So let's open that design viewer back up. Add the people, close it. Let's select person name, but this time, not select a sort type because you cannot sort a text field. And the person name is not a varchar field. It's actually named text. So we're going to click on okay. Let's delete the other query that has showed up, so now we just have select person name from People, and execute that query. I now have my results at the bottom. My name is Dave Andrews, and I've just showed you how to use the query designer in Microsoft SQL Server."