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