Hi, I've read several articles on importing XML into a SQL DB using different methods but I don't know if they are outdated or if one is preferred over the others. My XML file is as follows:
<?xml version="1.0" ?>
<CATEGORY id='181' name='Category name'>
Any advice on how best to do this would be appreciated. Also is there any software that will create a schema from an XML file?