Webmaster Forum / ASP / Database Access / March 2008

I am doing some scripting against a sql server database. In the course
of the scripting I update a text field of one of my tables and soon
after that run a select against that same table looking at the text
field.

For example,

update books set chapter1 = "some text about trees ..." where id = 99
.
<a few lines of work>
.
select id from books where chapter1 like '%trees%'

Is it possible that the second query is run before the update of
chapter1 from the first query is completed?