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...

What is the difference between views and stored procedures?
Can we have input parameters for views?

Answer Posted / indhu karur

View:
V can define a select-query that retrieves
specific information from one or more tables

Sp:
A stored procedure can do much more: it can run
multiple sql-commands, has control-of-flow statements and
accepts
parameters

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql injection and why is it a problem? : sql server security

1182


What is primary key and example?

992


How to define output parameters in stored procedures?

1077


What is a group function explain with an example?

1030


How can I add Reporting Services reports to my application?

132


What the class forname () does?

1133


How do you handle datasets larger than 50 gb?

164


How to connect of datebase with sql express.?

1142


Do you know query execution plan?

1260


What is an inner join?

1037


What is the fillfactor concept in indexes?

1032


Why use update_statistics command in sql server?

1107


What is a matrix in ssrs?

158


What are the rules to use the rowguidcol property to define a globally unique identifier column?

1073


How to use wildcard characters in like operations in ms sql server?

1185