Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

For XML Path/ WITH XMLNAMESPACES


Is it possible to create generate xsi:schemaLocation="http://
http://.../name.xsd" while using the for XML Path syntax? I am able to define
everthing else except that (see example) below. Any help would be greatly
appreciated...Thanks

Example:
<Example xmlns:xsi="http://..." xsi:schemaLocation="http://...
http://.../name.xsd" xmlns="http://...">

SQL Syntax (so far):
WITH XMLNAMESPACES (default 'http://...')
select
        x.id_example as 'ExampleID'
from table x
for xml path ('Transaction'),
        root('Example')   -- Generate Single Top level Element
    ,ELEMENTS XSINIL -- Adds Elements for Null Values (Also adds
"xmlns:xsi=...")

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc