<div>
Guess something must have installed incorrectly, I reinstalled and all is good
</div>


Guess something must have installed incorrectly, I reinstalled and all is good

<div>
<div class="content wysiwyg-content">
I just installed sql server 2000 and am trying to get the following statement to execute from query analyzer. &nbsp;However I get the Incorrect syntax near 'XML'.<br />
&nbsp; &nbsp; SELECT 1 as Tag<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;,0 as Parent<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;,Null as [user!1!user]<br />
&nbsp; &nbsp; FOR XML EXPLICIT
</div>
</div>


I just installed sql server 2000 and am trying to get the following statement to execute from query analyzer.  However I get the Incorrect syntax near 'XML'.
    SELECT 1 as Tag
           ,0 as Parent
           ,Null as [user!1!user]
    FOR XML EXPLICIT

Line 1: Incorrect syntax near 'XML'.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.