Pass where clause to a store procedure

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  November 2, 2015 at 8:33 am

  #304821

  From my one app, a dynamic where clause will generate like below.

  //where ordercity='london' and orderby='smith'

  //where orderamount > 100 and shipcity='new york'

  From server, I created a store procedure as below.

  SELECT * FROM [Order] WHERE @whereSql

  Help me to complete the store procedure so that I don't need to pass parameters one by one

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  November 2, 2015 at 8:36 am

  #1837116

  Sounds vaguely like a catch all query, where parameters can be null and not all need to be specified to execute the stored proc

  Maybe Gail's article will help http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/