SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL » CTE (RSS)

Browse by Tags

  • CTE in a View

    It is possible to use Common Table Expression in a View. But newbies wonder why the following is not possible create view numbers as with numbers ( n ) as ( select 1 as n union all select n + 1 from numbers where n < 10000 ) select n from numbers option ( maxrecursion 0 ) Which when created results...
    Posted to Madhivanan (Weblog) by Madhivanan on Sat, Jul 11 2009
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems