Stack Overflow
Stack Overflow

Questions tagged [xml-schema-collection]

34 questions
15
votes
1 answer

Modifying SQL Server Schema Collection

SQL Server XML Schema Collection is an interesting concept and I find it very useful when designing dynamic data content. However as I work my way through implementing Schema Collections, I find it very difficult to maintain them. Schema Collection…
mevdiven
  • 1,902
  • 2
  • 17
  • 33
5
votes
1 answer

Check for existence of an XML Schema Collection?

writing scripts for Sql Server 2005. I am registering a schema with CREATE XML SCHEMA COLLECTION [dbo].[MySchema] AS N'' Now, as I make changes, I would like to drop it, say with a call to DROP XML SCHEMA COLLECTION…
johnny g
  • 3,533
  • 1
  • 25
  • 40
2
votes
1 answer

EHF peppol 3.0 invoice for norway government

I am trying to generate xml file for the invoice which has to submitted in the form xml file EHF peppol 3.O, I unable to find the exact xml schema for this anybody can help me on this
S Mugunthan kumar
  • 177
  • 1
  • 2
  • 11
2
votes
1 answer

Using CONTENT keyword while creating a table with an XML column from XML Schema Collection

While creating a table that has an XML type column, I am referring to a complex XML Schema Collection. When I specify the XML Schema, I have the option of mentioning either CONTENT or DOCUMENT keyword. The latter will ensure that the XML data is…
Kabeer
  • 4,138
  • 7
  • 40
  • 62
2
votes
1 answer

How to iterate/traverse XML file elements( which contains different namespaces) to convert it as Data table in C#

I have a sample to read a xml schema set for a xml file which contains different namespaces. For this i can get different schema for each namespace as i explained below. Sample File:
Ajar
  • 162
  • 1
  • 10
1
vote
0 answers

Is there a way to impose a limit on the XML-type of a typed XML column in SQL Server?

I have two XML Schemas where one depends on the other, and I'd like to create a typed XML column in SQL Server where the type is defined by one of my schemas (actually I have hundreds of schemas but in principle it's the same). When I create the…
Kenned
  • 568
  • 4
  • 11
1
vote
1 answer

SQL Server XML Typed Column Size variance

In Sql server if we create a xml column with a schema associated to it (typed XML) will this help in reducing the space required to store the actual data. Example if i create 2 tables with XML column considering the data is same in both the tables…
Santy
  • 85
  • 1
  • 12
1
vote
1 answer

Reusable simpleType definition in SQL Server schema collection

I'm trying to create a reusable simpleType in an SQL Server XML schema collection but I'm getting an error. For example:
JHJ
  • 303
  • 1
  • 6
1
vote
1 answer

Modifying an existing XML Schema collection

I have schema collection association for an XML column. I want to add a child element to an existing parent in the schema collection. I am trying to achieve this without dropping the schema association because the table having that column contains…
Surya Prakash
  • 57
  • 12
1
vote
0 answers

Can not find the declaration of element "globalHotels"

I'm trying to write XML Schema for an XML Document. But unable to create element. Here is my XML Schema
Mohsin Ahmed
  • 21
  • 8
1
vote
2 answers

Get column names and types out of XMLSchema

I am working in c#, attempting to extract the column names and their types, out of an xml schema. Here is the schema as I receive it:
Brian Denomey
  • 166
  • 1
  • 2
  • 13
1
vote
1 answer

List in xsl schema mapping Java classes

How the list can be implemented in the XML schema (xsd )? So that the mapping with the Java class should create variable of java.util.List Type instead of Object Type ?
Deepak M
  • 223
  • 4
  • 14
1
vote
0 answers

How to update XML Schema Collection using SQL Server Merge Replication

I am testing using SQL Server 2014 to replicate (using Merge Replication) a database between two servers. I have already setup replication successfuly and I am now testing how to apply changes to the database. This database uses a few XML Schema…
lbarreira
  • 175
  • 10
1
vote
1 answer

Possible to query the create script for an XML Schema Collection?

As a first step to adding our SQL objects to version control I've written a script that will query sys.objects, sys.modules to script out all objects as CREATEs. I used an example from here to script out my tables. The goal is to preserve the…
alan
  • 6,705
  • 9
  • 40
  • 70
0
votes
1 answer

SQL Server XML schema validation; invalid content error; expecting element with minoccurs set to 0?

I have an XSD from a third party that I'm trying to use to create an XML schema collection in SQL Server and validate XML received from that third party. Upon validation, I receive an error: XML Validation: Invalid content. Expected element(s):…
Brad
  • 323
  • 2
  • 13
1
2 3