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

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

瀏覽:1079
日期:2025-06-13
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 ......看更多