Hi

Part of the reason to have a transaction is to maintain consistency,
therefore if the data has been updated it should then be shown to be the
updated value for a subsequent select statement. If you roll back the
transaction all data should be returned to their previous values
See Books online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acd
ata.chm::/ac_8_md_06_2it2.htm

If this is within a stored procedure, you may also want to make sure that
you return a status values that will indicate that the transaction has
completed or not.

John
[quoted text, click to view]

If I in a transaction Update a field to something,
can I then in the next row in the transactino do a Select * from table where
col = something

Im little confusing how to work with values who is not yet commited in
columns.

I was on a course and they talked about black values that I should not use
values in select querys who was not commited

Is i like this or can I sleep calm tonight


//Kenneth