As far as I can tell the at
keyword is considered 'standard' XQuery syntax.
for $a at $x in //Node/Details
return <node number="{$x}" />
For the T-SQL flavor of XQuery this produces the following error.
XQuery [query()]: The XQuery syntax 'at' is not supported.
How do you count the iterations in a T-SQL XQuery for-loop?