Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

1.what is the difference between view and cursor?

2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks

Answer Posted / bindu

Both Cursors and Views doesn't store data , so their is no chance to affect the DB.

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019


How do you run a trace?

893


What are the advantages of sql stored procedure?

1061


When I run the sql server 2000 setup, it just hangs. What do I do?

1072


How to maintain a fill factor in existing indexes?

996


What is a document index?

1020


What are different types of constraints?

916


What is role playing dimension with two examples? : sql server analysis services, ssas

996


How to use union to merge outputs from two queries together in ms sql server?

1058


Why do we need different type of parameter?

1049


How to concatenate two binary strings together?

1114


How to view the error log for any specific instance? : sql server database administration

1028


Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1382


Explain cdc and sql injection?

968


Explain error and transaction handling in sql server?

1005