If I update a view, will my original tables get updated

Posted by vaibhav on Stack Overflow See other posts from Stack Overflow or by vaibhav
Published on 2010-04-15T19:41:39Z Indexed on 2010/04/15 19:43 UTC
Read the original article Hit count: 147

Filed under:

sql-server-2005

|

views

|

sql

|

tsql

suppose I have tables Employee, Locations. and I have a view viewEmpLocation which is made by joining Employee and Locations.

Now If I update the view, will data in original table get updated.

© Stack Overflow or respective owner

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More

Related posts about views

A Custom View Engine with Dynamic View Location

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction: One of the nice feature of ASP.NET MVC framework is its pluggability. This means you can completely replace the default view engine(s) with a custom one. One of the reason for using a custom view… >>> More
DRUPAL, Views: I cannot change theme from Views settings

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I cannot change the css theme of my Drupal View. This is a screenshots of the settings: http://dl.dropbox.com/u/72686/viewTheme.png I've tried all buttons, I cannot save the new theme (BlueMarine) in the preferences. It is stuck on Zen (which is my front-end theme). thanks >>> More
Align views in the middle of anotehr views baseline in android

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi.how do u allign views relative to the "middle" part of another view? i think its best explained with a pic of the UI i am trying to create in android http://img228.imageshack.us/img228/3239/howtom.png Thanks in advance >>> More
Drupal, Views: display taxonomies as Views titles.

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I'm using Views for some nodes, and I want to display a different View title according to which taxonomy tags are selected in my filter. I already have taxonomy field for each node in my view. But this is not what I need. I basically need to display all the currently filtered tags on the top… >>> More
django {% tag %} problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I don't know if its me but {% tag ??? %} has bee behaving a bit sporadically round me (django ver 1.2.3). I have the following main.html file: <html> {% include 'main/main_css.html' %} <body> test! <a href="{% url login.views.logout_view %}">logout</a> test! <a href="{%… >>> More