Write DML SQL queries and answer the questions: Get the AdventureWorks Data Dict

Question

Write DML SQL queries and answer the questions: Get the AdventureWorks Data Dictionary from technet.microsoft.com/en-us/library/ms124438(v=sql.100).aspx

Use the SELECT and the WHERE clause to find the, Name, ProductNumber, and ReorderPoint, where the ProductID is 356

i.Submit the SQL statement used to accomplish this task

ii.Submit the value for the following fields: Name ProductNumber ReorderPoint

My ANSWER below is getting a query error message. Please help!!

Select Name,ProductNumber,ReorderPoint From Product Where ProductID=356;

Error Message: Msg 208, Level 16, State 1, Line 1 Invalid object name 'Product'.

Explanation / Answer

You are query is correct. Please do go through following checklist:

1. You are using correct database

2. Your database contains the Product table

3. You are trying to access the correct server

4. You have enought permissions to access the table.

Please put screenshot of error if this does not help.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.