XML到SQL Server Querry错误 [英] XML to SQL Server Querry Error
本文介绍了XML到SQL Server Querry错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试将XML文件详细信息添加到SQL Server,我做了很少的编码,却出错了,试图解决它但没有成功.这是我使用的代码.你能建议我在哪里改变
i am trying to add the XML file details to SQL Server, I did few coding, getting error, tried to solve it but unsuccessful. This is the code which i used. Can u suggest me where should i change
Dim xmlPath As New String("C:\USERS\Administrator\DESKTOP\xml FILES\books.xml")
Dim xmlQryAs String
xmlQry= "DECLARE @xml XML" + Environment.NewLine() + _
"SELECT @xml =" + _
"FROM OPENROWSET( BULK ''" + xmlPath + "'', SINGLE_BLOB ) " + Environment.NewLine() + _
"Insert into bkdetails " + Environment.NewLine() + _
"SELECT * " + Environment.NewLine() + _
"FROM " + Environment.NewLine() + _
"(SELECT TITLE,PRICE,GENRE FROM @xml.nodes(books.xml)" + Environment.NewLine()
Dim conn As New SqlConnection("Data Source=.\SQLExpress;Initial Catalog=Book_Details;Integrated Security=SSPI")
Dim cmd As New SqlCommand
With cmd
.Connection = conn
.CommandType = CommandType.Text
.CommandText = (AOSQL)
End With
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
关键字"FROM"附近的语法不正确.
由表值方法返回的表(及其列)需要别名.
Incorrect syntax near the keyword ''FROM''.
The table (and its columns) returned by a table-valued method need to be aliased.
推荐答案
Try
Try
xmlQry= "DECLARE @xml XML" + Environment.NewLine() + _
"SELECT @xml =" + _
"FROM OPENROWSET( BULK ''" + xmlPath + "'', SINGLE_BLOB ) " + Environment.NewLine() + _
"Insert into bkdetails " + Environment.NewLine() + _
"SELECT * " + Environment.NewLine() + _
"FROM " + Environment.NewLine() + _
"(SELECT TITLE,PRICE,GENRE FROM @xml.nodes(books.xml)) AS XMLBOOKS" + Environment.NewLine()
这篇关于XML到SQL Server Querry错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文