Dyanmic SQL in Search

• tarek_mohammed_eg

  SSC Enthusiast

  Points: 174

  More actions

  January 16, 2004 at 3:22 am

  #107135

  I read about COALESCE  to used instead of using Dynamic Search in SQL

  http://www.sqlteam.com/item.asp?ItemID=2077

  Is it really effective way and does it desrve solving some related problems. I can mentions the problems if anyone likes.

  Send question, is it better to use "IF Else" instead of using Dyanmic SQL stmt. and we really gain performance?

  I told my team to never use Dynamic SQL, does it can be done in realy world.

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  January 16, 2004 at 6:10 am

  #490400

  Since Frank seems to be uncharacteristically quiescent...

  Read this, not the article you reference:

  http://www.sommarskog.se/dyn-search.html

  Also, there are some things that cannot be done without dynamic SQL, so I would never say never...

  
  
  --Jonathan

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 16, 2004 at 6:42 am

  #490406

  Actually I was busy (I hate meetings with controllers)

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]