C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » SQL Server »

View


Posted Date: 04 Nov 2009      Posted By: shiji      Member Level: Silver     Points: 1   Responses: 5



Hi All,

What is the difference between table and view?
if we r updating the view is it updating the Disk?

Shiji





Responses

Author: VijayaShankar    04 Nov 2009Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

No both are different. We can store a huge query in view and used a single line for retrive that. If you update view it will modified in temp table.


Author: Lalji    04 Nov 2009Member Level: DiamondRating: 3 out of 53 out of 53 out of 5     Points: 3

you can try this link

http://www.ilopia.com/Articles/SQLServer/Views.aspx



Author: Anil Kumar Pandey    04 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

the views are modified in a temp table until you commit it.

Thanks & Regards
Anil Kumar Pandey



Author: Melchior    04 Nov 2009Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

Try this link
http://www.cvalde.net/features/f4/updatable_views.htm



Author: Nikhil Gaur    04 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

look at the following link

http://www.ilopia.com/Articles/SQLServer/Views.aspx

http://www.cvalde.net/features/f4/updatable_views.htm

Join this campus group
http://www.dotnetspider.com/sites/637/-ecb-aspdotnet.aspx

Thanks & Regards
NIks
My Software and Web Development Experience



Post Reply
You must Sign In to post a response.
Next : Retrive Parameters in Stored Procedure
Previous : How to copy and paste a db
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use