Member Avatar for Nikunjpatel

I have following query...

SELECT * FROM tblAccount
WHERE  intRegionId  in ([@intRegionid]);

if i put hardcoded values like

SELECT * FROM tblAccount
WHERE  intRegionId  in (2,3);

It returns value but if i try to do it with parameterized query such as SELECT * FROM tblAccount WHERE intRegionId in ([@intRegionid]);

& pass values there then no records selected.?

can you please help me what to do in this problem?

  • 2 Contributors
  • 1 Reply
  • 59 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by sandeepbhutani
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.