Re: Load XML File into Table from T-SQL (With no CLR)
- From: anonymous
- Date: Mon, 17 Jul 2006 12:20:51 -0700
DECLARE @c xml
SELECT @c = BulkColumn FROM OPENROWSET(BULK 'c:\temp\countries.xml', SINGLE_BLOB) AS A
INSERT INTO t_Countries SELECT T.C.value('Name[1]', 'VARCHAR(255)'),
T.C.value('ISOCode[1]', 'VARCHAR(2)'),
T.C.value('Language[1]', 'VARCHAR(255)')
FROM @c.nodes('Countries/Country') AS T(C)
Dan
.
- References:
- Load XML File into Table from T-SQL (With no CLR)
- From: Reeves Smith
- Load XML File into Table from T-SQL (With no CLR)
- Prev by Date: Load XML File into Table from T-SQL (With no CLR)
- Next by Date: Re: XML and Pound (£) Symbol
- Previous by thread: Load XML File into Table from T-SQL (With no CLR)
- Next by thread: PP: SP Unit
- Index(es):
Loading
