Which embedded-SQL statement should you use?

You are a Dynamics 365 Finance developer.

You have a table named FMVehicle that contains a field named Vehicleld. The table has a clustered index named Vehicleldldx on the Vehicleld field. You declare a table buffer named vehicle to refer to the table.

You need to select all records from the FMVehicle table in ascending order based on Vehicleld field in the vehicle variable.

Which embedded-SQL statement should you use?

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: C

Explanation:

All select statements use a table variable to fetch records. The results of a select statement are returned in a table buffer variable, here vehicle.

Reference: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-data-query