Sergey,
That conflicts with the rule-of-thumb: "Never use * when selecting, always specify the fields".
I know you are a very smart man, so I am wondering why you would do this.
Does it change performance or just reduce typing?
Einar
>I use '*' in subquery because the field list is irrelevant in this case.
>
IF NOT EXISTS(SELECT * FROM [MyTable] WHERE [PK] = @PK) ...
>
>
>
>>>
>>>
IF NOT EXISTS(SELECT [PK] FROM [MyTable] WHERE [PK] = @PK) ...
>>>
>>>If this query is used a lot, there should be a nonclustered index on PK.
>>
>>Thanks. Your way looks cleaner than my code.
>>
>>
Semper ubi sub ubi.