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, 1374🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...