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, 1335🔥, 0💬
Popular Posts:
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...