in Search
 
           
Welcome to SPAN Sign in | Join |
 
 

Need help on this lab practice also

Last post 04-20-2007, 11:02 PM by hoh. 0 replies.
Sort Posts: Previous Next
  •  04-20-2007, 11:02 PM 541

    Need help on this lab practice also

    You work as a database administrator at your company. Users report that insert statement against the view name Production.ExpiredProduct do not succeed. You confirm that the insert statements that are being used are valid.

    The only table that the view uses is named Production.ExpiredProduct. The table has the following definition:

    CREATE TABLE Production.ExpiredProduct {ExpiredProductID INT IDENTITY CONSTRAINT PKEXPIREProduct PRIMARY KEY

    Name NVARCHAR(50) NOT NULL

    ListPrice MONEY NULL}

    You need to ensure that the insert statements can be complete successfully. You need to apply the fewest possible changes, and you must use SQL Server Management Studio(SSMS).

View as RSS news feed in XML
 
SPAN © COPYRIGHTS 2006. |  PRIVACY STATEMENT  |  TERMS OF USE  | FAQ