4 ms·
This is pretty standard (it is how updatable views work in MSSQL). The advantage they provide is if you wanted to provide a limited view into a table (say 4 of
by hvs 13y ago
This is pretty standard (it is how updatable views work in MSSQL). The advantage they provide is if you wanted to provide a limited view into a table (say 4 of 20 columns) but still allow updates. Granted, that's a pretty small use case, but updating a view that spanned multiple tables could easily become a monster of a problem to solve generally.
- jpitz 13y ago>it is how updatable views work in MSSQL Not exactly. The updated columns may only unambiguously reference one table, but you can execute an update on a view which references multiple tables.