SQL SERVER 2005存储过程利用xml批量插入
create procedure procedureName
@xml xml
as
begin
insert into wannaInsertTableName
(
select x.c.value('ID[1]','int') as XX x.c.value('name[1]','varchar(50)')
from @xml.nodes('node') as
转载
2011-10-25 17:14:26 ·
1152 阅读 ·
0 评论