i have xml source. xml source having lacks of records. i
want extract/retrive xml source data using sql query.
please tell me how to write query.
Answer Posted / jagadeesh
create procedure proc_es
as
begin
declare @hdoc int
DECLARE @xml xml
set @xml=(select *
From openrowset(Bulk'C:\emp18.xml', single_blob) as xmldata)
exec sp_xml_preparedocument @hdoc output,@xml
insert into emp19(emp_id,emp_fname,emp_lname,emp_mail)
select *
from openxml(@hdoc,'/employee/details',3)
with(emp_id int,emp_firstname varchar(50),emp_lastname varchar(50),emp_mailid varchar(50))
exec sp_xml_removedocument @hdoc
end
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of indexes are there in sql?
How do I find duplicates in a single column in sql?
What is sqlservr exe?
What are all different types of collation sensitivity?
What is optimistic concurrency control? : Transact sql
how to get help information from the server? : Sql dba
How many types of privileges are available in sql?
What are the different types of joins in sql?
Explain autonomous transaction.
What are pl/sql cursor exceptions?
which operator is used in query for pattern matching? : Sql dba
Is left join same as join?
What is function and procedure?
Can we perform dml in function?
What is sql profiler in oracle?