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, 1283🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...