----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: ssv_2000 Message 7 in Discussion Hi vijrag, sorry for my previous message. It got messed up. By using the technique described in ur site to send across a bunch of records in one shot, I understand that the I/O time and time for which locks are held can be drasctically reduced. But in scenarios where a Stored Procedure is designed to update only one record at a time, for each record, the DAL object has to set the parameters and call the stored procedure. Transactions will have to be maintained by the calling DAL object as transactions normally span more than one record (like updating a whole order with item detail lines). In such scnearios will using stored procedures vs. sending direct SQL statements give a better performance? In sending across records in XML Format as varchar() variable, are there any security issues, length restrictions, possibilties of Injection Attacks etc? How do u handle Updates and Deletes with OpenXML()? Is there code for that anywhere in ur site? Thanks for helping me out. SriVidya. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
