Collections:
Inserting Data into a View in SQL Server
Can You Insert Data into a View in SQL Server?
✍: FYIcenter.com
Can you 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 tutorial exercise below shows you how to insert data into a underlying table through a view:
USE FyiCenterData; GO ALTER VIEW fyi_links_top AS SELECT TOP 3 id, counts, url FROM fyi_links WHERE counts > 100 ORDER BY counts DESC; GO INSERT INTO fyi_links_top VALUES(100001, 1000001, 'dba.fyicenter.com'); GO SELECT * FROM fyi_links_top; GO id counts url ------ ------- ------------------------------------------- 100001 1000001 dba.fyicenter.com 36470 999966 dgqnvmy pyjqd toqcoupuxortasdtzvcae jonfb 12292 999953 qebmw v qqmywe q kza wskxqns jnb SELECT TOP 1 * FROM fyi_links ORDER BY counts DESC; GO id url notes counts created ------ ----------------- ----- ----------- ---------- 100001 dba.fyicenter.com NULL 1000001 2007-05-19
⇒ Updating Data in a View in SQL Server
⇐ ALTER VIEW - Modifying Existing Views in SQL Server
2016-11-04, 1738🔥, 0💬
Popular Posts:
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...