insert data into view in sql

Hi,

Refer the below link to insert data into view.

http://www.java2s.com/Tutorial/SQLServer/0320__View/Insertintoaview.htm[^]

You task is depend on complexity of the view. If you create a view using single table, you can insert the data using normal insert statement. If you create complex view by joining multiple tables, this is bit hard. You may have to use "INSTEAD OF Triggers"

http://msdn.microsoft.com/en-us/library/ms175521.aspx

Hi
You can insert data into view if bellow conditions are ok.
1- your view getting data from table (some view hasn't table in it's background)
2- hole of columns in your view are insert-able
3- your view has not group by in construction
4- another columns in your tables(that your view is construct from they) have default value or are null-able

if upper conditions it's OK for your view you can use from bellow script for this action:

Insert [ServerName].[SchemaName].[ViewName] (FirstColumnName, ...)
Values(FirstColumnValue, ...)

HI,

Check the following links for your answer.

Insert data into a view (SQL Server)
nserting to a View

Thanks

Insert x in to blah. It's just a normal insert statement.

Hi,

Insert data directly into respective tables your view get automatically updated.