3 ms·
If you have a lot of values to add to a query, they're physically distant from the place you're using them. With the unnamed version like you used, you're relyi
by bastawhiz 3y ago
If you have a lot of values to add to a query, they're physically distant from the place you're using them. With the unnamed version like you used, you're relying on your ability to count how many values are used so you get the list correct. With named parameters, you're adding another layer of indirection. Use a value more than once? If you change it or want to remove it, you'd better be sure you do it for each usage of the name in your query!
- rmbyrro 3y agoAh, that indeed makes sense