Welcome to weblogs.com.pk Sign in | Join | Help

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));

Published Thursday, April 8, 2004 12:04 PM by khurram
Filed under:


No Comments

New Comments to this post are disabled