Using AdventureWorks examine the columns in the table Department in the HumanResources schema.

Document Content and Description Below

Using AdventureWorks examine the columns in the table Department in the HumanResources schema. Part 1- Using AdventureWorks examine the columns in the table Department in the HumanResources schema.... Add five new rows into the table for all columns that are not null. Examine the data and pick five DepartmentID values that will unique to meet primary key concerns. Take a screen shot of the SQL windows and results and paste it here. Part 2- Select the data from the table for the data inserted into Part 1 Take a screen shot of the SQL windows and results and paste it here. Part 1- Using AdventureWorks examine the columns in the table Department in the HumanResources schema. Add five new rows into the table for all columns that are not null. Examine the data and pick five DepartmentID values that will unique to meet primary key concerns. Take a screen shot of the SQL windows and results and paste it here. Part 2- Select the data from the table for the data inserted into Part 1 Take a screen shot of the SQL windows and results and paste it here. [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages