SQL Server Performance

Error - XML Auto

Discussion in 'T-SQL Performance Tuning for Developers' started by sachinsamuel, Oct 11, 2007.

  1. sachinsamuel New Member

    Hi Experts,
    Below code snippet works absolutly fine in SQL server 2005 but gives error in SQL server 2000.
    Can anybdy help and tell whats the reason and solutions for this?
    Regards
    Sachin
    ----------------Create
    table students(stid
    int,stname varchar(20)
    )insert
    into students values (1,'Sachin')insert
    into students values (2,'Rahul')DECLARE
    @T varchar(8000)SET
    @T = (SELECT stid,stname FROM [students] FOR XML AUTO, ELEMENTS)
    -----------------------
  2. satya Moderator

    What is the error?
    I doubt that may not be compatible with SQL2000.

Share This Page