Select from following answers:- Use the OFTYPE function in the FROM clause.
- Add the TREAT typecast to the SELECT clause.
- Add the TREAT typecast to a HAVING clause.
- All Above
The correct syntax to restrict by subtype is as follows:
SELECT VALUE employee FROM
OFTYPE(NorthwindDataEntities.Employee, NorthwindDataLib.Manager) AS employee
where NorthwindDataEntities.Employee is a collection and NorthwindDataLib.Manager is a subtype.
Show Correct Answer
Source: MeasureUp.Com | |
Alert Moderator