Does anyone know if SQL Azure supp开发者_运维百科orts CTE syntax? Specifically; WITH OVER ROW_NUMBER()
My stored procedure looks like: WITH MYCTE(...开发者_JAVA百科.) AS ( ... ) UPDATE ... (using my CTE) DELETE ( using my CTE)<---says the object, my CTE, doesn\'t exist
I have a complex query that I need to use in a subsequent query (actually update statement).I have tried both using a CTE and a temp table.The performance using the CTE is horrible vs the temp table a
加载中,请稍侯......