Duration: 17:59 min
Summary: In this video, we will start discussing the select statement. Now that we have SQL Server 2012 installed, we will start writing queries against the AdventureWorks 2012 database. We will start first by creating a new query page where we will write our statements. Then, we will use a simple select statement that retrieved rows from the Employee table. We will explain the purpose of the schema and modify our statement accordingly. After running the statement, we move our attention to the result section. We will see how we can copy our results (with and without the headers) so we can use them somewhere else. We will also look at different options of selecting all the columns versus some of them.
Technologies and Resources:T-SQL, AdventureWorks 2012, Select.