Which would be more optimized of the two queries given below when using
T-Sql


IF (SELECT TOP 1 1 FROM table_name WHERE column_name = 'xxx')
BEGIN
-- code here
END

OR

IF EXISTS (SELECT 1 FROM table_name WHERE column_name = 'xxx')
BEGIN
-- code here
END


Of course IF EXISTS (SELECT TOP 1 1 FROM table_name WHERE column_name =
'xxx') should be the fastest, but among the two given which would be
faster

Hi,

there is no difference between using

IF EXISTS (SELECT 1 FROM table_name WHERE column_name = 'xxx')
BEGIN
-- code here
END

Or

IF EXISTS (SELECT * FROM table_name WHERE column_name = 'xxx')
BEGIN
-- code here
END

There is only a check for existence as no row is given back.

HTH, Jens Suessmeyer.