how to pass xml for stored procedure in sql server 2000 from vb6

• • Reply

  13 years ago

  by avinash5

  avi pawar

  Pune, India

  Joined 14 years ago

  my self avi i m developing one application in vb6 and sql server 2000 which is run on lan.

  i want to send bulk data [i.e. some sort of array one can say.] to stored proc. i send it by concatenating data by "," and in stored proc i split it but i dont want to do this i want some other effective method or i want to pass the xml but i dont know how to pass xml to stored proc and how it parse. plz any one can explain it m with e.g i.e by giving some code sample

  thanx in advance

  Report abuse