How to insert data into view in sql server 2000?

Question

Pls tell me the syntax how can we insert data in view in sql server 2000

Answer 1

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Answer 2

You can't. Data can be inserted only into tables. Views are made only to view data, not to update it. Some databases (e.g. Access do allow to update tables through views, but not SQL Server).
If you want to update multiple tables at the time, try to make a stored procedure instead.

Answer 3

it truly is an celebration to stick with: sq. = "insert into product (Product_id,Product_name,Product_price) values(7,'Product7',seven-hundred)" try connection.Open() adapter.InsertCommand = New SqlCommand(sq., connection) adapter.InsertCommand.ExecuteNonQuery(... MsgBox("Row inserted !! ") seize ex As Exception MsgBox(ex.ToString) end try replace the numbers in values along with your textual content field values.