my stored proc. gets xml document. I've to insert data from xml doc. to corresponding fields of tables.If i create permanent XML SCHEMA COLLECTION and a table to store xml everything works fine.
It is something like this...
CREATE XML SCHEMA COLLECTION MyABCCollection AS
    N'<?xml version="1.0" encoding="utf-16"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">...
..........................>';

CREATE TABLE XMLTable
       (id INT identity(1,1) , xDoc XML (MyABCCollection ))

And then read each element by XQuery

But i'm not able to create temperory schema and table. I need to create temp. schema and xmltable so that after execution of stored proc. it get removed. And is there any performance issues?



Bijgupt

__________________
Bijgupt