Hov044 10 Report post Posted August 15, 2006 Hallo Leute, könnte einer von euch mir bei der Frage helfen, bin mir bei der antwort nicht sicher! Ich tendiere auf B (es über die Spalte zu suchen), was meint ihr so? You are a database developer for Company.com You are designing a query that calculates the number of orders that were made on October 27, 2005. The Orders table is designed as shown in the following display. OderID (PK) OrderDate … int datetime … An index is defined on the OrderDate column. You need to design the query to provide the fastest performance. Which Transact-SQL query should you use? A. SELECT COUNT(*) FROM OrdersWHERE OrderDate BETWEEN '2005-10-26T00:00:00' AND '2005-10-28T00:00:00' B. SELECT COUNT(*) FROM OrdersWHERE CONVERT(CHAR(8), OrderDate, 112) = '20051027' C. SELECT COUNT(*) FROM OrdersWHERE YEAR(OrderDate) = 2005 AND MONTH(OrderDate) = 10 AND DAY(OrderDate) = 27 D. SELECT COUNT(*) FROM OrdersWHERE DATEDIFF(day, OrderDate, '20051027') = 0 SELECT COUNT(*) FROM OrdersWHERE OrderDate >= '20051027' AND OrderDate < '20051028' Vielen Danke!!!! Quote Share this post Link to post