Stored Procedure for Inserting/Updating XML Column in Table..

• Aswanth

  Mr or Mrs. 500

  Points: 548

  More actions

  August 7, 2008 at 1:17 am

  #195609

  Hi, I want the Stored Procedure for Inserting/Updating Data in Table in Sql Server 2005..

  I'm having Get_data-->Table with C_ID, C_Name, Start_Date, Status---> Columns

  Here Status is XML Datatype Column.. i want to Insert / Update(if Data is Present) the XML Type Data in this Column..

  my input fields are C_ID, Time_Now, Views, Click

  I want to get Result in Status Column for Particular C_ID as..

  &ltStatus&gt

  &ltDate /&gt

  &ltTime Time_Now="2008-08-07 16:06:51.280" Views="1" Click="1" /&gt

  &ltTime Time_Now="2008-08-07 20:06:45.280" Views="5" Click="2" /&gt

  ---------------------------------------------

  ---------------------------------------------

  &lt/Status&gt

  ie here Time_Now = getdate()

  Thank You..

• abmore

  Hall of Fame

  Points: 3628

  More actions

  August 7, 2008 at 3:16 am

  #854293

  you can use the exist method of xml to search the data