Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8133 Views
- TCS, I also Faced
- E-Mail Answers
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
Is mariadb a nosql database?
Who is the owner of mysql database?
Can we use two order by clause in query?
explain the difference between myisam static and myisam dynamic. : Sql dba
Why do we need unique key in a table?
what is offset-fetch filter in tsql? : Transact sql
How do I view a sql database?
Why is a primary key important?
What is the difference between delete and truncate statement in sql?
what are all the common sql function? : Sql dba
what is subquery? : Sql dba
What is difference between function and trigger?
What is sql keyword?
what does myisamchk do? : Sql dba
Can we join same table in sql?
