March 7, 2009 at 10:50 am
code snippet:
CREATE XML SCHEMA COLLECTION MovieSchema AS N'
<xs:schema xmlns="http://schemas.sqlservercentral.com/MovieSchema"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
';
GO
this works well but i'm unable to add schema for a attribute called "status" to element "releaseDate".
I'm able to add disctype,category to element "film", can anybody suggest/help what i'm missing with.
Thanks in advance.
March 7, 2009 at 8:59 pm
We cannot see most of you schema, because the security on these forums will filter out most text that looks like XML or HTML. Please post your XML as an attached file, either as TXT or a ZIP.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 7:43 am
pls see the schema attached
March 9, 2009 at 8:36 am
What have you tried? And what has happened when you tried it? (tell us the error message if there is one)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 8:50 am
By the way, If you really want to put the XML in your post, you can use one of the following methods:
* Replace all "<" and ">" with "[" and "]"
* Replace all "<" and ">" with "& lt;" and "& gt;" (except no space)
* use the Simple-Talk prettifier here: http://extras.sqlservercentral.com/prettifier/prettifier.aspx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply