Answers

Question and Answer:

  Home  MS SQL Server

⟩ Can We Insert Data into a View?

The answer is no.

But if the question is "Can you insert data into the underlying table through view?" The answer is then yes. SQL Server will allow you to insert data into the underlying table through a view with a condition:

* The insert columns must be limited to columns of a single underlying table.

The tutorial exercise below shows you how to insert data into a underlying table through a view:

USE GlobalGuideLineDatabase;

GO

ALTER VIEW ggl_links_top AS

SELECT TOP 3 id, counts, url FROM ggl_links

WHERE counts > 100

ORDER BY counts DESC;

GO

INSERT INTO ggl_links_top

VALUES(100001, 1000001, 'rendc.org');

GO

SELECT * FROM ggl_links_top;

GO

id counts url

------ ------- -------------------------------------------

100001 1000001 rendc.org

36470 999966 dgqtzvcae jonfb

12292 999953 ggl wskxqns job

SELECT TOP 1 * FROM ggl_links ORDER BY counts DESC;

GO

id url notes counts created

------ ------------------- ----- ----------- ---------- 100001 rendc.org NULL 1000001 2007-05-19

 128 views

More Questions for you: