[sql] Do we need to execute Commit statement after Update in SQL Server

I have done some update to my record through SQL Server Manager.

As Update statement is not having explicit commit, I am trying to write it manually.

Update mytable
set status=0;
Commit;

I am getting message as Commit has no begin transaction

Sql server unlike oracle does not need commits unless you are using transactions.
Immediatly after your update statement the table will be commited, don't use the commit command in this scenario.