Share via

SQL Server Where 1=0

  • Article

SQL Server Where 1=0

Used in both static and dynamic query.

WHERE 1 = 0 (or any always false condition) 

It is used to create a table of identical structure, sans data: In the below query empty table is created in the same structure.

SELECT * INTO dbo.NewTable FROM dbo.SomeTable WHERE 0 = 1;