Ok, to understand short circuit take this example

CREATE TABLE Test_Circuit (

a INT NOT NULL PRIMARY KEY CLUSTERED,

b VARCHAR(128) NULL,

c INT NULL

)

and input values as below

col1 col2 col3

111

222

333

444

5abc5

Now run below scripts one by one, do you find any difference...

Script 1.

SELECT *

FROM

Test_circuit

WHERE

ISNUMERIC(b)= 1 and b < 10

Script 2.

SELECT *

FROM

Test_circuit

WHERE

b < 10 and ISNUMERIC(b)= 1