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 the difference between ddl,dml and dcl commands?

1114


Can a database be shrunk with users active?

1137


What is dynamic cursor in SQL SERVER?

1084


What is trigger explain with program?

986


Explain trigger and trigger types?

987


what kind of lan types do you know? : Sql server database administration

980


What happens if null values are involved in bitwise operations?

1030


Explain transaction server consistency?

979


What is equi join with example?

1134


Which sql server is best?

999


What is shared lock?

907


Please differentiate between a local and a global temporary table?

1008


What is sub query and its properties?

974


what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

994


How does Report Builder support Analysis Services cubes?

156