Collections:
Deleting Data from a View in SQL Server
Can You Delete Data from a View in SQL Server?
✍: FYIcenter.com
Can you delete data in a view? The answer is no.
But if the question is "Can you delete data from the underlying table through view?" The answer is then yes. SQL Server will allow you to delete data from the underlying table through a view. The tutorial exercise below is a good example:
DELETE FROM fyi_links_top WHERE id = 100001; GO SELECT * FROM fyi_links_top; GO 36470 999966 dgqnvmy pyjqd toqcoupuxortasdtzvcae jonfb 12292 999953 qebmw v qqmywe q kza wskxqns jnb 6192 999943 p o qisvrakk hk od SELECT TOP 1 * FROM fyi_links ORDER BY counts DESC; GO id url ... ------ ------------------------------------------- ... 36470 dgqnvmy pyjqd toqcoupuxortasdtzvcae jonfb ... 999966 1977-09-08 04:28:01.523
⇒ Assigning New Column Names in a View in SQL Server
⇐ Updating Data in a View in SQL Server
2016-11-03, 1267🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...