You are a Dynamics 365 Finance developer.

You have a table named FMVehicle that contains a field named VehicleId.

The table has an index named VehicleIdIdx on the VehicleId 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 VehicleId field in the vehicle variable.

Which embedded-SQL statement should you use?

Question

You are a Dynamics 365 Finance developer.

You have a table named FMVehicle that contains a field named VehicleId.

The table has an index named VehicleIdIdx on the VehicleId 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 VehicleId field in the vehicle variable.

Which embedded-SQL statement should you use?

Exam-Answer · Accepted Answer

select vehicle index VehicleIdIdx;

Embedded-SQL Statement for Selecting Records in Ascending Order | MB-500 Exam | Microsoft