Yes, We can also use where 1=1 ro get all the data in resultset specifically we should used when we make DYNAMIC WHERE CONDITION in query like,
DECLARE @SQL1 VARCHAR(800),
@WhereCondition varchar(8000),
@WhereConditionParam VARCHAR(8000);
SET @WhereConditionParam = 'AND param = 1'; /* this is coming from proc or code*/
SET @SQL1 = 'SELECT * FROM TABLE1';
SET @WhereCondition = 'WHERE 1=1 ';
SET @WhereCondition = @WhereCondition + @WhereConditionParam ;
SET @SQL1 = @SQL1 + @WhereCondition ;
EXEC (@SQL1);
commented on Jun 2 2011 6:02AM