Can anyone explain me the commit statement in sql server.Please clarity my doubts. [Resolved]

Posted by Arjunan_Csharp under Sql Server on 1/24/2013 | Points: 10 | Views : 879 | Status : [Member] | Replies : 2
1)Query1

Delete from Employee where EmployeeID=3;

2)Query2
Begin Transaction
Delete from Employee where EmployeeID=3;
Commit Transaction

Query1 - I saw the results after executing the first query with the select statement.It's deleting the record.

Query2 - It's also doing the same operation.What is the real difference?




Responses

Posted by: Arul44ece on: 1/24/2013 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi Friend,

Please refer the below link.

http://www.sqlserver2005tutorial.com/Tutorial-Learn-Stored-Procedures-Transactions-Types-Implementing.html

http://msdn.microsoft.com/en-us/library/ms181299.aspx



Regards,

Arul R
arul44.ece@gmail.com

Arjunan_Csharp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Arjunan_Csharp on: 1/24/2013 [Member] Starter | Points: 25

Up
0
Down
Thanks

Arjunan_Csharp, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response