Home Forums SQL Server 2005 T-SQL (SS2K5) 'ROOT' directive in SELECT query RE: 'ROOT' directive in SELECT query

  • December 20, 2007 at 8:20 am

    #761773

    I am not having a problem and here is test case.

    select database_id,name

    from master.sys.databases

    wheredatabase_id <= 5

    FOR XML AUTO, ELEMENTS, ROOT('databases')

    SQL = Scarcely Qualifies as a Language