Solved

Line 1: Incorrect syntax near 'XML'.

Posted on 2002-07-10
2
288 Views
Last Modified: 2006-11-17
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
0
Comment
Question by:maytr
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
ID: 7144096
Maybe the database is in compatibility mode 7 (sql server 7), because I tried your syntax and got no error...

CHeers
0
 

Author Comment

by:maytr
ID: 7144498
Guess something must have installed incorrectly, I reinstalled and all is good
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question