sql server - Rollback in SQL

Question

I have the following query:

use valid
begin transaction t1
go
delete from dbo.do
rollback transaction t1
go

With rollback I want to undo the delete operation. Do not get any results, what is wrong?

Answer 1

Try without the "go" after begin transaction.