Use the Lab: Structured Query Language (SQL) Queries with Data Manipulation Lang

Use the Lab: Structured Query Language (SQL) Queries with Data Manipulation Language (DML) Worksheet file (found in the Resources section), populate the tables you created above using SQL Insert statements. Note that there are multiple sheets in this workbook. Each sheet contains data for a separate table. You may find it easier to create formulas in your Excel file to generate “insert” statements and then paste those queries into a sql script file. Conversely, you may find it easier to pull the data from Excel into Microsoft Access and import it directly into SQL Server using ODBC. To use this latter technique, refer to the “How to Import Data from Access to SQL Server” document in your lab folder. Once the data are loaded, execute the following SELECT statements in SQL Server and paste a screenshot of your results below each SELECT query in the Lab: SQL Queries with DML Template, located on the assignment page. Make sure your screenshot includes the bottom status bar in the query results window that indicates the number of rows displaye