Are these two sql statements the same (northwind)?

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  November 19, 2003 at 4:01 pm

  #151979

  Are both sql statements below functionally the same thing? Is one better than the other?

  -- cut here --

  USE NORTHWIND

  GO

  SELECT SUM(Discount)

  FROM [ORDERS] X INNER JOIN [ORDER DETAILS] Y ON X.ORDERID = Y.ORDERID

  WHERE X.FREIGHT BETWEEN 0 AND 10 AND X.EMPLOYEEID = 5

  GO

  SELECT SUM(Discount)

  FROM [ORDERS] X INNER JOIN [ORDER DETAILS] Y ON (X.ORDERID = Y.ORDERID AND X.EMPLOYEEID = 5)

  WHERE X.FREIGHT BETWEEN 0 AND 10

  GO

  -- cut here --

  thanks in advance

  Billy

• GRN

  Hall of Fame

  Points: 3260

  More actions

  November 20, 2003 at 12:09 am

  #482789

  Yes they are the same,there would be no difference in execution of both..

  i personally prefer to put my constants in the where clause , but that would have no difference in the query plan in this instance