help on xml schema

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » help on xml schema

help on xml schema

Rate Topic

Display Mode

Topic Options

Author

Message

Biswa Mahapatra

Posted Saturday, March 07, 2009 10:50 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 6:19 AM
Points: 10, Visits: 203

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.

Post Attachments

movieschema.txt (8 views, 1.11 KB)

Post #670940

RBarryYoung

Posted Saturday, March 07, 2009 8:59 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #671047

Biswa Mahapatra

Posted Monday, March 09, 2009 7:43 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 6:19 AM
Points: 10, Visits: 203

pls see the schema attached

Post #671486

RBarryYoung

Posted Monday, March 09, 2009 8:36 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

What have you tried? And what has happened when you tried it? (tell us the error message if there is one)

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #671562

RBarryYoung

Posted Monday, March 09, 2009 8:50 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #671583

« Prev Topic | Next Topic »

Permissions