Dynamic Query

• Matin

  SSC Veteran

  Points: 247

  More actions

  December 30, 2008 at 6:45 am

  #199411

  Hi All,

  How to write dynamic query ?

  Thanks

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  December 30, 2008 at 6:52 am

  #919006

  Matin (12/30/2008)

  ---

  Hi All,

  How to write dynamic query ?

  Thanks

  Make sure you read this fully

  www.sommarskog.se/dynamic_sql.html

  ---

  Madhivanan

  Failing to plan is Planning to fail

• ps.

  One Orange Chip

  Points: 29422

  More actions

  December 30, 2008 at 8:51 am

  #919089

  Read Andy's article on dynamic queries to grasp the concept.

  http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/

  Also http://www.sqlservercentral.com/articles/Security/dynamicsqlversusstaticsqlp1/617/

  contains couple of example along with pros and cons of using dynamic sql.

  ---

  
  Pradeep Singh