Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashraff87
Starting Member
17 Posts |
 Posted - 2008-08-07 : 06:13:23
|
| Is it at all possible to do inserts into views? how does it work does it propergate to the tables that the view is based on?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-07 : 06:31:14
|
Yes it is possible.Try.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-07 : 11:04:10
|
| But the created view should not contain any aggregate functions and also should satisfy lot other conditions for you to modify it.http://blog.sqlauthority.com/2007/04/28/sql-server-restrictions-of-views-t-sql-view-limitations/ |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-08-07 : 11:41:53
|
| I would agree with the above, there are a lot of limitations and if you are going to insert through a view its always easier on a view that only contains a single table***************************Life is for having Fun, and then a little SQL Server on the side |
|
|
|
|
|
|
Inserts into Views