June 30, 2009 at 12:36 am
The view named Production.vExpensiveExpiredProduct do not succeed.
I had 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 { ExpiredProductIDINT IDENTITY CONSTRAINT PK_EXPIREProduct
PRIMARY KEY Name NVARCHAR(50) NOT NULL ListPrice MONEY NULL }
I need to ensure that insert statements can be complete successfully and apply the fewest possible changes, using SQL Server Management Studio (SSMS).
Please help me...
June 30, 2009 at 12:46 am
Pleas provide us the view definition as well, the insert statement that doesn’t work and the error message that you get. Without this information, we can only guess what went wrong.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply