XML !!!! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

XML !!!!

Author

Topic

dbserver2000
Starting Member

47 Posts

Posted - 2009-04-30 : 21:36:37

Why Do I get this error message:

Msg 9436, Level 16, State 1, Line 4
XML parsing: line 3, character 39, end tag does not match start tag

When I try to execute the understated?

--Insert untyped data
USE XMLTest
DECLARE @xmlInsert XML
SET @xmLInsert =
'<project>
<projectname>Employee Database</projectname>
<Startdate>1994-06010Z</startDate>
<endate>2008-05-05Z</enddate>
<manager>Darril Gibson</manager>
<scope>Create database for employee</scope>
<project/>'
INSERT INTO Project
VALUES (@xmlInsert)

If I double click on the error message, it highlights
SET @xmLInsert =

nathans
Aged Yak Warrior

938 Posts

Posted - 2009-04-30 : 22:39:43

You have a few typos:
1. Startdate <> startDate
2. endate <> enddate
3. <project/> should be </project>

Nathan Skerl

dbserver2000
Starting Member

47 Posts

Posted - 2009-04-30 : 22:44:35

Thanks, that did it.

Was not aware that XML is case sensitive, opposed to T-SQL

Thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources