• (2 Pages)
  • +
  • 1
  • 2

Parameterizing your SQL Queries: The RIGHT way to query a database.

#16 albert018  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 23
  • Joined: 07-January 13

Posted 28 January 2013 - 09:03 AM

I got another interesting question.

how to translate the following segment of code into parameter?

select * from employee where idno in ('A00001','B00001','C00001')



Is there any suggestion about it??
Was This Post Helpful? 0
  • +
  • -

#17 Curtis Rutland  Icon User is offline

  • (╯□)╯︵ (~ .o.)~
  • member icon


Reputation: 4577
  • View blog
  • Posts: 8,019
  • Joined: 08-June 10

Posted 28 January 2013 - 09:14 AM

That's a lot more complex, since they don't have a proper built in mechanism to handle that. Here's an article on how you can achieve the same results:

http://www.codeproje...tored-Procedure
Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2