1,105,416 Community Members

How to generate Dynamic where condition for single stored procedure

Member Avatar
korathualex
Light Poster
41 posts since Jan 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

How to generate Dynamic where condition for single stored procedure and pass from code behind asp.net....

Member Avatar
pritaeas
mod_pritaeas
11,317 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

You can pass the where clause as a parameter to your stored procedure, but that means you'll need to build your query as a string, and use sp_executesql to execute it.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: