Post reply

Xml validation with xsd

  • June 24, 2008 at 4:23 am

    #189482

    I'm learning at my job how to validate xml documents or fragments with xsd , and I would like to know how to link a xml document or fragment with xml schema definition , and in my xml document or fragment i to say tha is xml refers to database table "xxxxx" and colum "yyyy".how can i do that.

    Can any one help me with this?

    it's urgent!!!

  • June 24, 2008 at 1:23 pm

    #833566

    hi

    you have to look for "xsd annotations"

    and "schema collection"

    you will find a way to accomplish it

    with the SqlXml 3.0 or greater

    which is an IIS-SqlServer interface (dll)

    everything works:

    schema transformations and mappings

    but i can't make the transformations and mapping works

    inside a stored procedure

    there is no information

    if you need to transform and map

    on a simple query, inside a a s.proc

    or a query window on the "sqlserver management studio"

    that is,

    create a "xml" variable

    and then "select @var" applying the schema

    please, you post any further step!

    ks

  • June 30, 2008 at 5:12 am

    #836020

    thanks !!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply