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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mathivanan
select extractvalue(columnname,'/roottag/subtag') from tablename
Is This Answer Correct ? | 0 Yes | 0 No |
What are triggers and its types?
What are conditional predicates?
What is data abstraction in sql?
How to select random rows from a table?
How to know the last executed procedure?
What are the sql versions?
What is primary key and foreign key with example?
What is the use of index in sql?
What does pl sql stand for?
Can we join two tables without common column?
What are Lexical Parameters.How They are used in Reports 6i
Is delete faster than truncate?