how to use commit or rollback statement in the the SQL

Question

Abhishek Srivasatava · Answer

Hi Elena Glibart,and 
Below is the answer for your question:and 
SQL COMMIT Statement:
It is mainly use while creating transaction for SQL query.
Transaction is the set of statement to perform the task.
COMMIT statement is used to save the changes performed by the transaction statement.
and 
BEGIN TRANand  TR1 --(Creating transaction)and INSERT INTO EE_EMPL_CAT4 (PRSN_INTN_ID, [EMPL_STAT_CD],[NAME],REFERENCE_ID)and and and  VALUES (565545, 'ACTIVE', 'R Raturi',159978)and and and  and COMMIT;and and GO
and 
SQL ROLLBACK Statement:Rollback is used if there is any sort of error occurs while performing any set of transaction.For example there are 3 table, data need to update in all three table. If this task need to be done by single transaction then by chance any table is not able to update because of any reason then rollback function undo all the changes.BEGIN TRANand  TR1and INSERT INTO EE_EMPL_CAT4 (PRSN_INTN_ID, [EMPL_STAT_CD],[NAME],REFERENCE_ID)and and and  VALUES (56116545, 'ACTIVE', 'DAVID',159978)and and  ROLLBACK ;and GO
and

forum

how to use commit or rollback statement in the the SQL

Elena Glibart

Can you answer this question?

1 Answers

Liked By