1- William logs into the database
2- Julianna logs into the database
3- William sees 12 rows in the TOYS table
How does he "see" 12 rows? SELECT TOP 12? SELECT *? WITH(NOLOCK)? GUI?
4- Isabelle logs into the database
5- Julianna sees 12 rows in the TOYS table
Again... How does she "see" 12 rows? SELECT TOP 12? SELECT *? WITH(NOLOCK)? GUI?
6- William inserts two rows into the TOYS table
7- Julianna inserts 14 rows into the TOYS table
8- Isabelle issues a COMMIT
Isabelle gets an error...
9- William issues a ROLLBACK
10- Julianna looks at the TOYS table
Once again... How does she "see" 12 rows? SELECT TOP 12? SELECT *? WITH(NOLOCK)? GUI?
Jared
CE - Microsoft