DECLARE @idoc int;
DECLARE @doc xml;
SELECT @doc=bulkcolumn FROM OPENROWSET(
BULK 'c:/student.xml',
SINGLE_BLOB) AS x
EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc
SELECT * into temp FROM OPENXML (@Idoc, '/DocumentElement/student',2)
WITH (
[考生号] varchar(20)
,[姓名]varchar(20)
,[身份证号]varchar(50)
,[家庭住址]varchar(100)
,[所属省份]varchar(50)
)
select * from temp
drop table temp