如何将数据从xml文档插入到sql server表中？ [英] how to insert data from xml document into sql server table?

问题描述

亲爱的朋友们......



我有一个xml文档，我想将该xml文档中的数据加载到基于该文档创建的新表中。这就是为什么我写了下面的查询，但它抛出了一个错误

 选择 * 进入 t 来自 
（ SELECT   10 ，xCol 
  FROM （ SELECT  * 
  FROM   OPENROWSET （ BULK  '  C：\ Users \ TAUSEEF \Desktop\test.xml'，SINGLE_CLOB）
  AS  xCol） AS  R（xCol））

错误：



消息102，等级15，状态1，行5

'）'附近的语法不正确。



请帮帮我

解决方案

尝试使用它，

 选择 *  into  t  from  
（ SELECT   10 ，xCol 
  FROM （ SELECT  * 
  FROM   OPENROWSET （ BULK  '  C：\ Users \ TAUSEEF \Desktop\test.xml'，SINGLE_CLOB）
  AS  xCol） AS  R（xCol））a 

你好TAUSEEF，



除了deepankarbhatnagar的回答，



请尝试以下查询。在内部查询中，列名称应为列值10。

 选择 * 进入 t 来自 
（  SELECT   10   as  Col1，xCol 
  FROM （ SELECT  * 
  FROM   OPENROWSET （ BULK  ' < span class =code-string> C：\ Users \ TAUSEEF \Desktop\test.xml'，SINGLE_CLOB）
  AS  xCol） AS  R（xCol））a 

如果您对此有任何疑虑或疑问，或者您遇到任何其他问题，请与我们联系。



Th anks

Dear Friends...

i have a xml document and i want to load data from that xml document into new table created based on that document. That's why i have written following query but it throws an error

 select * into t from
(SELECT 10, xCol
FROM    (SELECT *
    FROM OPENROWSET (BULK 'C:\Users\TAUSEEF\Desktop\test.xml', SINGLE_CLOB)
 AS xCol) AS R(xCol))

Error:

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ')'.

Please help me

解决方案

Try to use this,

select * into t from
(SELECT 10, xCol
FROM    (SELECT *
    FROM OPENROWSET (BULK 'C:\Users\TAUSEEF\Desktop\test.xml', SINGLE_CLOB)
 AS xCol) AS R(xCol)) a

Hi TAUSEEF,

In addition to the answer of deepankarbhatnagar,

Please try with below query. In the inner query, column name should be there for the column value 10.

select * into t from
(SELECT 10 as Col1, xCol
FROM    (SELECT *
    FROM OPENROWSET (BULK 'C:\Users\TAUSEEF\Desktop\test.xml', SINGLE_CLOB)
 AS xCol) AS R(xCol)) a

Please let me know if you have any concern or query on this or if you are facing any other issue.

Thanks

这篇关于如何将数据从xml文档插入到sql server表中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！