Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Update Query

Author  Topic 

vmurali
Yak Posting Veteran

88 Posts

Posted - 2007-01-19 : 01:26:21
How do we write the update statement when input is as xml. I am using Stored Procedure.
Suppose my xml is as
<table tablename="Leave_info">
<col colname="Emp_Code" colvalue="906342" />
<col colname="Approve_Reject" colvalue="Reject" />
<col colname="Approve_date" colvalue="1/2/2007" />
</table>

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-19 : 01:31:10
Duplicate:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77790

Tara Kizer
Go to Top of Page

Benjamin78
Spammer

4 Posts

Posted - 2007-01-26 : 11:21:42
*** spam removed ***
Go to Top of Page
   

- Advertisement -