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-02-01 : 08:39:36
|
Damien O writes "I originally programmed a lot of my web based queries as dynamic sql statements inside stored procedures (DSSISP for brevity). The problems with doing this is that most of the benefits of stored procedures are lost (Query plans etc), and debugging can be tiresome.
Then my T-SQL got better I found I could replace DSSISP with a combination of Joins and Case statements. Thereby regaining all the SP benefits
So the question is, can T-SQL cater for all possible queries that developers usually turn to DSSISP, or are there some possible conditions which just cannot be solved by T-SQL?
Knowing this will decide for me whether to persist with complex queries, or throw in the towel and turn to DSSISP without the guilt.
Thanks
Damien
web developer
theage.com.au" |
|
|
|
|
|
Using Dynamic SQL Statements in Stored Procedures (DSSISP)