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, 1511🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...