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, 1272🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...