Microsoft KB Archive/80398

{|
 * width="100%"|

PRB: View Created with a Subquery Cannot Be Updated

 * }

Q80398

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2
 * Microsoft SQL Server version 4.2x

-

SYMPTOMS
A view created using a subquery cannot be updated. An attempt to update a view created with a subquery generates the following message:

View  is not updatable because it contains aggregates. (Msg 4403, Level 16, State 1).

CAUSE
This is similar to the case where a view created with an aggregate cannot be updated. This happens because the subqueries are processed as a special type of aggregate, and therefore few significant differences exist between aggregate and subquery processing.

According to ANSI (X3.135-1989), a view cannot be updated if it includes a subquery.

Additional query words: Windows NT

Keywords : kbother

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2