TSql Wishes (Part 1)
TSQL’s IN keyword has tremendous power; using it one can determine the given value matches any value in a sub query or list. For example;
select userid from users where accountindex in (14, 17);
I wish, that modern languages like Java/C# offers same kind of keyword that can ease many implementation scenarios.
I also wish, that TSQL’s IN keyword is extended to support multi-column matches, I-e something like:
--Users having invalid groups
select userid from users where (groupname, accountindex) not in (
select groupname, accountindex from allowedgroups where accountindex in (14, 17));