June 17, 2011 at 6:58 am
hi friends,
can any one explain me the advantages of stored Procedure over view
June 17, 2011 at 7:01 am
What's an "over view"? Never heard of such a thing.
A "view"? Sure. An "over view"? No clue.
Assuming you mean "view", and misunderstood the question you're being asked, then they are two different things with two different uses, and comparing them is like asking what the advantages are of tablesaws over power drills. But saying that won't help you in an interview, test, or homework, if that's what this is.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2011 at 7:08 am
ghousebmd (6/17/2011)
can any one explain me the advantages of over view and stored Procedure
Assuming you mean "view" - never heard about "over view" you sholdn't ask about "advantages" but about "differences".
Second alternative is that you teacher is asking for an "Overview on Stored procedures" 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 17, 2011 at 7:12 am
yes, you people are right, i was mistaken...the right question i have is....
advantages of stored procedures compared to views
June 17, 2011 at 7:17 am
Well unless you are willing to share you salary we aren't going to do your homework for you. There is plenty of information on this site and across the internet about both views and stored procedures. I agree with Jeff that comparing them is similar to comparing apples and tuna fish.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 20, 2011 at 6:08 am
ghousebmd (6/17/2011)
yes, you people are right, i was mistaken...the right question i have is....advantages of stored procedures compared to views
Stored procedures can perform more complex actions, and can take input parameters. On the other hand, you can't join to a stored procedure (well, not easily anyway), and you can't Select From one without jumping through the same hoops.
Most likely, what your teacher/interviewer was looking for is the old "stored procedures are precompiled and thus run faster", which is just plain false, but huge numbers of people believe it anyway.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply