Passing integer lists in a sql query, best practices
- by Artiom Chilaru
I'm currently looking at ways to pass lists of integers in a SQL query, and try to decide which of them is best in which situation, what are the benefots of each, and what are the pitfalls, what should be avoided :)
Right now I know of 3 ways that we currently use in our application.
1) Table valued parameter:
Create a new Table Valued Parameter…