Connect XML to SQL Server?

[MarkGG]

Is there a way to connect XML to SQL Server?

I haven't been able to find anything solid on this subject through Google. I can't use asp code on the XML page so what else can I do?

Thanks
-Mark

[Richard Conyard]

Tell you what, start again with the question and we'll try an answer.

Alternatively:
http://www.google.co.uk/url?sa=t&ct=res&cd=2&url=http%3A//msdn.microsoft.com/library/en-us/dnanchor/html/anch_sqlxml.asp&ei=ZIQUQ7jmHMDYwgH43IjsDg