SQL Azure and support for CTE syntax?
Does anyone know if SQL Azure supp开发者_运维百科orts CTE syntax? Specifically;
WITH
OVER
ROW_NUMBER()
PARTITION BY
Yep. See here - "WITH common_table_expression" is listed as supported. I would assume that means all of the above.
精彩评论