XML到SQL Server Querry错误 [英] XML to SQL Server Querry Error

问题描述

我正在尝试将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屋！