Roll back in sql

Question

I used rollback conceptn in my proceduer in dom table

after execute then i ran the table like

select * from dom

but the query executed contionuosly not stopped how can i stop this

pls help

Answer 1

From your comment, you have this:

create proc
    dom1
as

begin

begin trans
    insert into dom(value)
if flag=0
    rollback trans
else
    commit

So what is flag? What is value? How are you passing in the value?

I don't think your code is useful for us to help you.

Take a look at Books Online for more information about ROLLBACK, or make it easier for us to help you.