Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-04 : 08:49:57
|
| EdenD writes "My developers team is currently evaluating SQL stored procedures and SQL views. I would like to know really what are the disadvantages and advantages of using SQL stored procedures and SQL views. Another is, what is more recommended between the two. If both are of equal capacity, please identify the trade-offs of using each. Pls give me idea as to the speed on records retrieval using these two methods. Another, since I'm using VB as my programming language, what are the benefits of using SELECT-SQL in VB source codes than the SQL views or stored procedures? Thanks, I would greatly appreciate whatever help you could extend." |
|
|
|
|
|
Disadvantages and Advantages of using Stored Procedures and SQL View, Which would you recommend?