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

explain what is mysql? : Sql dba

1082

---

Why is partition used in sql?

1123

---

What are analytical functions in sql?

1029

---

Name three sql operations that perform a sort.

1014

---

Is sql an operating system?

1020

---

Is stored procedure faster than query?

969

---

How can you save or place your msg in a table?

1002

---

explain primary keys and auto increment fields in mysql : sql dba

977

---

What are different types of tables in sql?

998

---

how many ways to get the current time? : Sql dba

1007

---

How do you use a while loop in pl sql?

1014

---

What is pl sql block structure?

1037

---

What is sql profiling in oracle?

1065

---

what are the drivers in mysql? : Sql dba

1021

---

Does group by remove duplicates?

1045

---