How should the SQL query be specified in the CommandText property of the SqlQuery component?

You have a requirement that must return the OrderDate, OrderStatus, and OrderAmount for all orders for a given customer account in a SQL database.

How should the SQL query be specified in the CommandText property of the SqlQuery component?
A . SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber= {accountNumber}
B . SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber=? accountNumber
C . SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber={0}
D . SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber=@accountNumber

View Answer

Answer: A

Explanation:

Reference: http://help.openspan.com/80/Components/SQL_Query.htm