Posted by: Pdfprep
Post Date: December 15, 2020
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
Answer: A
Explanation:
Reference: http://help.openspan.com/80/Components/SQL_Query.htm
Leave a Reply