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 08, 2004 12:04 PM by khurram
Filed under:

Comments

No Comments

New Comments to this post are disabled