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-08-20 : 09:52:16
|
| Nic writes "My question revolves around performance and maintainability in a data driven ASP site. (I'm using SQLServer2000) I'm curious on peoples ideas on using dynamic sql in a set of "generalized" stored procedure versus defining and creating many small stored procedures for a number of specific events. Does anybody have any guidelines, ideas on when a SQL statement becomes too complex and should be broken down into a unique stored procedure or is it better to limit the number of stored procedures and use more dynamic SQL to build my statements. Thoughts? Ideas? Thanks" |
|
|
|
|
|
Dynamic SQL versus Many Stored Procedures