SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table) | Journey to SQL Aut

I have a same kind of scenario to address… If you have a database where you have lots of stored procedures in which you create dynamic tables, we make sure that the table doesnt exists, so we write: IF EXISTS (SELECT * FROM sys.objects WHERE object_id ...

blog.sqlauthority.com