sqlserver中 where :
如果前面的条件不满足,后面不会执行。
USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL
DROP TABLE t
GO
CREATE TABLE t(
id INT IDENTITY(1,1) PRIMARY KEY,
c1 VARCHAR(20),
c2 INT
)
GO
SET NOCOUNT ON;
INSERT INTO t(c1,c2) VALUES(NULL,0),(1,3)
SELECT *
FROM t AS a
WHERE
1=1
AND try_cast(c1 AS INT) IS NOT NULL --条件1,注释后会提示 遇到以零作除数错误。
AND 2/c2>0