Insert multiple records using Mysql Transaction

Question

1.00/5 (1 vote)

See more:

Hi,
I would need your help. I have a project that I need to insert multiple records into my table. Here is more detail.
I design a purchase order table and purchaseorderdetails
purchaseorder
PURCHASE_ORDER_ID
PO_DATE
CLIENT_ID
purchaseorderdetails
PURCHASE_ORDER_DETAILS_ID
PURCHASE_ORDER_ID
ITEM_ID
ITEM_AMOUNT
Could you please send me the stored procedure that allows how to have multiple records insert into

Posted 20-Aug-12 22:49pm

Dhrisya P Nair

Updated 21-Aug-12 11:57am

Wes Aday

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Naga KOTA · Answer 1 · 2012-08-20T23:03:00

hi,

this may be useful for u

SQL

DECLARE @ID int

BEGIN TRANSACTION 
INSERT INTO tbl_user_login VALUES (@UserID, @Pass, @Enabled, @Permission, @Rank)

SET @ID = SCOPE_IDENTITY()    
IF @@ERROR <> 0
BEGIN      
    ROLLBACK     
    RETURN 
END   

INSERT INTO tbl_user_profile VALUES (@ID, @FName, @LName, @Phone, @Email1, @Email2) 

IF @@ERROR <> 0 
BEGIN     
    ROLLBACK     
    RETURN 
END  

COMMIT

Wendelius · Answer 2 · 2012-08-21T11:27:00

Solution 2

When executing the SQL statement from the client side, wrap them inside a MySqlTransaction[^]

Posted 21-Aug-12 11:27am

Wendelius

Insert multiple records using Mysql Transaction

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Insert multiple records using Mysql Transaction

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us