Collections:
Updating Data in a View in SQL Server
Can You Update Data in a View in SQL Server?
✍: FYIcenter.com
Can you update data in a view? The answer is no.
But if the question is "Can you update data in the underlying table through view?" The answer is then yes. SQL Server will allow you to update data in the underlying table through a view. The tutorial exercise below is a good example:
UPDATE fyi_links_top SET url = REVERSE(url) WHERE id = 100001; GO SELECT * FROM fyi_links_top; GO id counts url ------ ------- ------------------------------------------- 100001 1000001 moc.retneciyf.abd 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 moc.retneciyf.abd NULL 1000001 2007-05-19
⇒ Deleting Data from a View in SQL Server
⇐ Inserting Data into a View in SQL Server
2016-11-04, 1457🔥, 0💬
Popular Posts:
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...