What you want to see on DotNetFunda.com ?
DotNetFunda.Com Logo
Twitter TwitterLinkedIn
YouTubeGoogle
 Online : 1152 |  Welcome, Guest!   Register  Login
 Home > Forums > Sql Server > Data update in view , need some help ...
Ray.chayan

Data update in view , need some help

Replies: 4 | Posted by: Ray.chayan on 7/21/2010 | Category: Sql Server Forums | Views: 1222 | Status: [Member]  


Suppose I have created a view from more than 1 table. There is also a where claues in the select query of the view. Now I am updating all the data of a particular column of the View. Is it possible in this condition?

If updation is possible then is it reflect in the main table data?

what happen to those data are that are not in where clause in main table? Is this updation occur to those data?


Reply | Reply with attachment | Alert Moderator

 Responses below this adGet hundreds of .NET Tips and Tricks videos

 Replies

Vikvish
Vikvish  
Posted on: 7/21/2010 1:06:18 AM
Level: Starter | Status: [Member]

you can view only those data in your created VIEW which is in your main table. Whatever you make changes in ur main table it will reflect in your created VIEW. if u update the records in your VIEW it will update in your main table too.

Those data which u wants to update but not in your main table will not do any updation.

with regards
vik.

vikram

Ray.chayan, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

PandianS
PandianS  
Posted on: 7/21/2010 5:45:17 AM
Level: Silver | Status: [Member] [MVP]

Hi

"If modification affects multiple base tables used in VIEW" then You can not do that.

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Ray.chayan, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

Neeks
Neeks  
Posted on: 7/21/2010 12:12:59 PM
Level: Bronze | Status: [Member]

View is used to store the Definition not the data, If you are modifying the data in view from more than one table it is not possible.

Thanks,

Ray.chayan, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

Sriramnandha
Sriramnandha  
Posted on: 6/26/2012 1:45:12 AM
Level: Starter | Status: [Member] | Points: 25

view is stored only defination.view it wont occupy any data.u cant update more than one table.

regards

sriram

Ray.chayan, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

Reply - Please login to reply


Click here to login & reply

Found interesting? Add this to:


 Latest Posts

Write New Post | More ...

About Us | Contact Us | The Team | Advertise | Software Development | Write for us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 5/25/2013 11:36:32 PM