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, 1250🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...