Can you call ROW_NUMBER () in dynamic sql and use Common Table Expressions in Dynamic Sql?

Question

Can you call ROW_NUMBER () in dynamic sql and use Common Table Expressions in Dynamic Sql?

I want to limit the number of records returned by the ROW_NUMBER () call, but I'm curious if it can be called in dynamic sql?

Also, can you use CTEs in dynamic sql?

0

sql-server tsql

Xaisoft Dec 10. 08:34 pm

source to share

1 answer

James orr · Accepted Answer · 2008-12-10T20:36:40+0000

Do you mean as opposed to calling from a stored procedure or other code object? If the question is, the answer is yes . Note to record that row_number is only supported in SQL 2005 and later.

Can you call ROW_NUMBER () in dynamic sql and use Common Table Expressions in Dynamic Sql?

More articles: