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

Is null vs coalesce?

862


How do I get to sql server configuration manager?

1001


How to filter records of table in SQL SERVER?

1077


Explain syntax for viewing trigger?

912


What is optimistic concurrency?

1029


What is the return type of executeupdate ()?

896


How do I run a trace in sql server?

976


Write a sql query to delete duplicate records from a table called table1

1022


Why is normalisation important?

936


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2009


What is the sql case statement used for? Explain with an example?

987


What is openrowset sql server?

1118


What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1079


What is trigger in salesforce?

972


SQL Server Architecture ?

2439