RadhaKrishnaKiJaya
asked on
Create a table with XML column
Hi Experts,
I am trying to create a simple table with 2 columns as below. Is there a simple way to create the table and insert data to it? Specially to Resume column being XML data type, I had hard time understanding it? Thank you in advance.
Column Data Type
----------- --------------
Id Integer
Resume XML
I am trying to create a simple table with 2 columns as below. Is there a simple way to create the table and insert data to it? Specially to Resume column being XML data type, I had hard time understanding it? Thank you in advance.
Column Data Type
----------- --------------
Id Integer
Resume XML
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
The xml data type is nothing else than VARCHAR + some integrity checks + some xml functions you can apply on the columns...