MS SQL Server Concepts and Programming Question:
Can We Update Data in a View?
Answer:
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:
<pre>UPDATE ggl_links_top SET url = REVERSE(url)
WHERE id = 100001;
GO
SELECT * FROM ggl_links_top;
GO
id counts url
------ ------- -------------------------------------------
100001 1000001 globalguideline.com
36470 999966 dgqnvmy pyjqd toqcoupuxortasdtzvcae jonfb
12292 999953 qebmw v qqmywe q kza wskxqns jnb
SELECT TOP 1 * FROM ggl_links ORDER BY counts DESC;
GO
id url notes counts created
------ ------------------- ----- ----------- ----------
100001 globalguideline.com NULL 1000001 2007-05-19</pre>
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:
<pre>UPDATE ggl_links_top SET url = REVERSE(url)
WHERE id = 100001;
GO
SELECT * FROM ggl_links_top;
GO
id counts url
------ ------- -------------------------------------------
100001 1000001 globalguideline.com
36470 999966 dgqnvmy pyjqd toqcoupuxortasdtzvcae jonfb
12292 999953 qebmw v qqmywe q kza wskxqns jnb
SELECT TOP 1 * FROM ggl_links ORDER BY counts DESC;
GO
id url notes counts created
------ ------------------- ----- ----------- ----------
100001 globalguideline.com NULL 1000001 2007-05-19</pre>
| Previous Question | Next Question |
| Can We Insert Data into a View? | Can We Delete Data from a View? |