i have xml source. xml source having lacks of records. i want extract/retrive

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.

Question Posted / sreenu

4 Answers
7007 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have xml source. xml source having lacks of records. i want extract/retrive xml source data usin..

Answer / naren

select e.getclobVal() from table name e;

Is This Answer Correct ?

2 Yes

1 No

i have xml source. xml source having lacks of records. i want extract/retrive xml source data usin..

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

i have xml source. xml source having lacks of records. i want extract/retrive xml source data usin..

Answer / yalamanda

select top 100 percent * from table_name..

Is This Answer Correct ?

0 Yes

0 No

i have xml source. xml source having lacks of records. i want extract/retrive xml source data usin..

Answer / mathivanan

select extractvalue(columnname,'/roottag/subtag') from tablename

Is This Answer Correct ?

0 Yes

0 No

Post New Answer