Skip to main content

All Questions

0 votes
0 answers
388 views

Filter the data inside a stored procedure using Table-Value parameters

I have a stored procedure which receives multiple table-type parameters and I want to filter the data using those parameters. The problem with that is those parameters can contain no rows and in that ...
Paul Muresan's user avatar
5 votes
2 answers
3k views

Parameter sniffing on table valued parameters

I'm fairly certain that adding parameter sniffing to table valued parameters is of little or no value however I was wondering if someone could confirm this? (INT_LIST is a user defined table type ...
Señor Cardgage's user avatar