Passing table names to Stored Procedures.

• Adam Bagarella

  SSC Enthusiast

  Points: 154

  More actions

  September 18, 2006 at 11:54 am

  #367428

  Hello again,

  The questions keep coming

  Is there anyway to pass the name of a table into a stored procedure?

  The reason is this. I am implementing Search functionality in my program. I could make a different stored procedure for a search on each field. However, it would be easier if I could create one and have the program pass which fields to search.

  So you'd have a SP called usp_search_customers, that could handle all customer searching.

  For example, the program would let it know it wants to search in "residential_customers" where "LastName" begins with "S". But I don't want to harcode the table name or field, so they can be passed.

  I'm not sure if this is possible, but I'd prefer it to making a different SP for each table and field.

  Thanks.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 18, 2006 at 12:19 pm

  #661107

  I don't have time to answer your question in detail... but this should do the trick .

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