openxml in sql server
OPENXML (Transact-SQL)
OPENXML provides a rowset view over an XML document. Because OPENXML is a rowset provider, OPENXML can be used in Transact-SQL statements in which rowset providers such as a table, view, or the OPENROWSET function can appear.
https://docs.microsoft.com/en-us/sql/t-sql/functions/openxml-transact-sql?view=sql-server-2017
XML System Stored Procedures
SQL Server provides the following system stored procedures that are used together with OPENXML:
-
sp_xml_removedocument (Transact-SQL)
To write queries by using OPENXML, you must first create an internal representation of the XML document by calling sp_xml_preparedocument. The stored procedure returns a handle to the internal representation of the XML document. This handle is then passed to OPENXML. OPENXML provides rowset views of the document based on XPaths. Specifically, this is one row pattern and one or more column patterns.
Note
The document handle that is returned by sp_xml_preparedocument is valid for the duration of the session.
The internal representation of an XML document can be removed from memory by calling the sp_xml_removedocument system stored procedure.
已经不建议用这个
https://stackoverflow.com/questions/49272564/openxml-returning-null
https://stackoverrun.com/cn/q/1573581
相关文章
- SQL Server-聚焦INNER JOIN AND IN性能分析(十四)
- Sql server在另一台服务器,在Visual Studio 中没问题,IIS中 提示“在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。。。。”
- Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data?
- How can I list all foreign keys referencing a given table in SQL Server? 查找已知表的字段被哪些表,用来做外键关联字段
- string interpolation in sql server
- numeric and int in sql server
- SQL Server Object Explorer in VS
- sql server 数据库表中增加列,增加字段,插入列,插入字段,修改列,修改字段,
- [更新1.0:EXP公开]CVE-2020-0618: 微软 SQL Server 报表服务远程代码执行漏洞通告
- 【威胁通告】微软 SQL Server 远程代码执行漏洞(CVE-2020-0618)威胁通告
- cmd常用命令 和 sql server相关基础
- (数据科学学习手册28)SQL server 2012中的查询语句汇总
- 使用 My SQL Server 实现数据科学的 SQL 查询教程
- sql server 小技巧(6) Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "Chinese_PRC_CI_AS" in the equal to operation
- SQL Server: Get table primary key and Foreign Key using sql query
- sql server 数据分析优化实战(一)——SQL语句优化
- sql server 还原数据库,数据库提示正在还原中的处理办法
- SQL Server-聚焦NOT EXISTS AND NOT IN性能分析(十五)
- 基于MS SQL Server的数据库学习安排
- (4.61)sql server执行SQL遇到错误不中断
- sql server联机丛书
- (1.2)sql server for linux 开启代理服务(SQL AGENT),使用T-SQL新建作业
- 【生产问题】sql server还原一个很小的BAK文件,但却花了很长时间,分析过程
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server