How to insert new data in a SQL View table
Posted on 2014-08-04
I need to know how to update a SQL View in SQL Server Management Studio 2012. When I run the insert statement another table is update and not the view.
1.) Can I insersert data into a SQL View
- The view is writeable
2.) If I can insert data into a SQL View how do I do this?
3.) Why is the view not inserting the new data and the other table is inserted the new data. Which causes duplicate rows?
4.) If I can not insert new data into a view how does the view get new data inserted into it?
My insert statement is a typical statement.
INSERT INTO dbo.view_Table (Column1, Column2, Column3, etc.....) VALUES ('data1', 'data2', data3', etc.....)