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

Contrast between an interface and abstract class?

935

---

Is lazy t thread safe?

903

---

What are types of constructor?

845

---

List out two different types of errors in c#?

889

---

What is the difference between firstordefault and singleordefault?

853

---

What is c# console application?

894

---

What is a multicast delegate in c#?

957

---

What is jagged array?

884

---

Is there hashmap in c#?

884

---

How can I develop an application that automatically updates itself from the web?

852

---

Is unity object oriented?

866

---

what is the default access for a class

1048

---

Is null in c#?

819

---

code for arranging given number in possible permutation ways ex:123,321,312,132,231,213.

2126

---

What are the types of access modifiers?

880

---