Commit and Rollback samples

Hi,
In my SQL Server 2000, I would like to test the COMMIT and ROLLBACK.
Would some give me some suggestions?
Thanks for help.
JasonBEGIN TRANSACTION
GO
USE pubs
GO
SELECT * from roysched WHERE title_id LIKE 'Pc%'
GO
UPDATE roysched
SET royalty = royalty * 1.10
WHERE title_id LIKE 'Pc%'
GO
SELECT * from roysched WHERE title_id LIKE 'Pc%'
GO
ROLLBACK TRANSACTION -- change ROLLBACK to COMMIT if you need to
commit the changes
GO
SELECT * from roysched WHERE title_id LIKE 'Pc%'
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:ODukuPipGHA.4368@.TK2MSFTNGP05.phx.gbl...
> Hi,
> In my SQL Server 2000, I would like to test the COMMIT and ROLLBACK.
> Would some give me some suggestions?
> Thanks for help.
>
> Jason
>