Common Table Expressions in SQL Server 2005

Question

Common Table Expressions in SQL Server 2005

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply

nileshsane Default port Points: 1465 More actions · Answer 1

Nice article. Cleared a lot of grey areas regarding CTE for me.

I have a doubt though, given the uses of a CTE, isint it similar to table variables then? I mean where is the result stored and how performant is a CTE as copmared to a table variable.

Pardon my ignorance if I am asking a question which should have an obvious answer.

What I hear I forget, what I see I remember, what I do I understand

srchan SSC Journeyman Points: 88 More actions · Answer 2

Well you are not alone I am also wondering how a CTE compares to a table variable performance wise.

Thank You