SQL script than create table and and fill it out file Resources.resx

Question

I need to write a sql script that will create a table in the database and populate it with data from the file type Resources.resx

As far as I can see, there are only 3 fields: Name, Value and Comment. All string.

I using Microsoft SQL Server (Management Studio)

<data name="Filter" xml:space="preserve">
<value>Фильтры</value></data>

This is a statement, not a question. Please tell us your actual problem. — steoleary, Jul 01 '13 at 13:09
I need import this data (Resources.resx) in table in Microsoft Sql Server, using sql scripts. Sorry by low English) Thanks=) — Dmitry Tetchenko, Jul 01 '13 at 13:14
yes, data of Resources.resx (no header) contains only this rows — Dmitry Tetchenko, Jul 01 '13 at 13:34

Devart · Accepted Answer · 2013-07-01T14:04:33.947

0

Try this one -

DECLARE @XML XML
SELECT @XML = '
<data name="Filter" xml:space="preserve">
     <value>Фильтры</value>
</data>'

CREATE TABLE dbo.translations
(
      name VARCHAR(100)
    , value NVARCHAR(200)
)

INSERT INTO dbo.translations (name, value)
SELECT 
       name = t.c.value('@name', 'VARCHAR(100)')
     , value = t.c.value('./value[1]', 'NVARCHAR(200)')
FROM @XML.nodes('data') t(c)

SELECT * 
FROM dbo.translations

Output -

name       value
---------- ----------
Filter     Фильтры

edited Jul 01 '13 at 14:04

answered Jul 01 '13 at 13:43

Devart

119,203
23
166
186

Thanks:) But how I can copy table from result of query to my table or create new table in database with this data? – Dmitry Tetchenko Jul 01 '13 at 13:53
Just specify in which table you want insert data for the file. Please see the updated answer. – Devart Jul 01 '13 at 13:55
An new empty table "translations" with 2 cols (name and value (varchar)) – Dmitry Tetchenko Jul 01 '13 at 13:57

SQL script than create table and and fill it out file Resources.resx

1 Answers1