⟩ 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 ASSELECT 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