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 - 2005-12-05 : 08:15:14
|
| AbdelMohsen writes "Optional PArameters VS Dynamic SQLDears, I'm Working on aa ASP.NET Website (MS SQL SWERVER 2000) which I have to search in the Data Base using optional parameters FOR STORED PROCEDURE I tried (Col=@PAram OR Param is Null) but this affected the performance ...As I may have optional parameter from 6 ~ 15 parameter in some cases..I saw many Articles on the web about how to build a dynamic SQL Query but I don't know the affect on security & where to build the query in my Code or in the SQL Server which one is better,In Performance & Security.Please advice..Best Regards" |
|
|
jhermiz
3564 Posts |
Posted - 2005-12-05 : 10:20:00
|
How badly does it affect performance? I cant see dynamic sql doing a much better job? Got any code to post? Got any indexes on the fields? Explain the table structure. And all that good stuff.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url] |
 |
|
|
|
|
|
Need HELP ASAP? Plz