Member Avatar for korathualex

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

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.