How to generate Dynamic where condition for single stored procedure

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

2

Contributors

1

Reply

2 Hours

Discussion Span

2 Months Ago

Last Updated

5

Views

korathualex

Light Poster

41 posts since Jan 2013

Reputation Points: 0

Solved Threads: 0

Skill Endorsements: 0

2 Months Ago

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.

pritaeas

Posting Prodigy

Moderator

9,317 posts since Jul 2006

Reputation Points: 1,178

Solved Threads: 1,467

Skill Endorsements: 86