How to insert multiple records in a table using a stored procedure

[Vikram_Lakhotia]

New Message on dotNET User Group Hyd How to insert multiple records in a table using a stored procedure Reply   Reply to Sender   Recommend Message 1 in Discussion From: Vikram_Lakhotia Hi Many a times we have to insert multiple data on click of one button. Like inserting all the checked records in the favorite table of the member. It is not a good idea to insert the records by using as many insert queries. At these points we should insert all the records with only one call to the database. We can use a stored procedure that takes a comma (or any separator you want to use) list of values and insert them in the database. This way the whole process will be very fast and efficient. http://www.vikramlakhotia.com/Inserting_multiple_records_using_one_stored_procedure.aspx Hope this helps Thanks Vikram http://www.vikramlakhotia.com View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. 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. Remove my e-mail address from dotNET User Group Hyd.