Home Forums SQL Server 2005 SQL Server 2005 General Discussion sql server table valued function parameter issue RE: sql server table valued function parameter issue

  • September 5, 2012 at 6:45 am

    #1533768

    Lowell (9/5/2012)

    nzhang6666 (9/5/2012)

    Just found out. The compatible level of the database is set to sql server 2000 (8.0).

    I didn't know function can not be used in parameters of a table valued function in 2000...

    But I can run a query with recursive CTE on the database, does 2000 supports CTE?

    best way to find out is to try it yourself...but no, CTE's will not work in 2000/ 80 compatibility...you have to change it to subqueries.

    That's what I was thinking, but I just run a CTE, and it worked.

    ;with cte(a) as (

    select 1

    union all

    select a + 1

    from cte

    where a < 10

    )

    select * from cte