Answer Posted / arindamrudra

If the XML Document comes like this

@XmlDocument ='<PARAMS><STATIC><INTERVIEWDATETIME>2/13/2009</INTERVIEWDATETIME></STATIC></PARAMS>'

We will have to write

EXEC sp_xml_preparedocument @docHandle OUTPUT, @XmlDocument

@docHandle and @XmlDocument are variable of datatype int and XML respectively.


then we have to use the similar type of code to get the value from XML and the variables should be taken on the basis of the datatype coming from the XML.

DECLARE @date1 DATETIME
SELECT
@date1=Date11
FROM OPENXML(@docHandle, 'PARAMS/STATIC', 1)
WITH
(Date11 DATETIME 'INTERVIEWDATETIME')
EXEC sp_xml_removedocument @docHandle

What is the difference between static and constant variables?

1061

---

Can property be private in c#?

875

---

Define property in c#.net?

953

---

Why c# is called c sharp?

884

---

What is difference between class and abstract class in c#?

911

---

What is a console device?

896

---

What is the difference between string and string in c#?

970

---

Is array passed by reference in c#?

956

---

What is a race condition?

890

---

State two different types of access modifiers.

995

---

Illustrate serialization?

949

---

What are functions in c#?

906

---

What do you understand by an Implicit Variable?

1001

---

Is vs as c#?

894

---

What is default parameter in c#?

960

---