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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JeganKumar
5 years, 6 months ago