This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have an Array of size around 500, which contains bill numbers. I want to search whether these values are in database or not.
I can easily write Select count (id) from Table where BNO=Array ; I am using little java also here because I am writing the code in java. But I have to run this query for 500 times if I need to search all values. I can’t use SPs in my application.
So is there any way I can do this in a simple way.