xml中有空值节点，导入到数据库null值
DECLARE @X TABLE ( XXML XML )
INSERT @X
SELECT ‘<STUDENTINFO>
<student ID="1" name="Karthi">
<subject ID="1" Name="Electronics and Communication" />
<subject ID="2" Name="Circuit Analysis" />
<subject ID="3" Name="Mobile Communication" />
</student>
<student ID="2" name="Vikram">
<subject ID="4" Name="Data Structure" />
<subject Name="NULL" />
<subject ID="6" Name="Database Management System" />
</student>
</STUDENTINFO>‘
CREATE TABLE Subject_Master
(
ID INT NULL,
NAME NVARCHAR(30)
)
INSERT INTO Subject_Master
SELECT ISNULL(tab.col.value(‘@ID[1]‘, ‘INT‘),
NULL) SubjectID ,
ISNULL(tab.col.value(‘@Name[1]‘, ‘NVARCHAR(30)‘),
‘Attribute Is Missing‘) SubjectName
FROM @X
CROSS APPLY XXML.nodes(‘/STUDENTINFO/student/subject‘) tab ( col )
SELECT *
FROM Subject_Master
--DROP TABLE subject_master
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
