Re: MSSQL NoLock vs MySQL NoLock

2006-10-31 Thread Ow Mun Heng
On Tue, 2006-10-31 at 10:35 -0600, Dan Nelson wrote: > In the last episode (Oct 31), Ow Mun Heng said: > > Just wanted to post this here to see if anyone knows the difference. > > > > In MSSQL, there is a hint which can be used to ask the DB to not lock > > the tables during queries and then to re

Re: MSSQL NoLock vs MySQL NoLock

2006-10-31 Thread Dan Nelson
In the last episode (Oct 31), Ow Mun Heng said: > Just wanted to post this here to see if anyone knows the difference. > > In MSSQL, there is a hint which can be used to ask the DB to not lock > the tables during queries and then to read un-commited/dirty data. > This command is like > > select c

MSSQL NoLock vs MySQL NoLock

2006-10-30 Thread Ow Mun Heng
Hi, Just wanted to post this here to see if anyone knows the difference. In MSSQL, there is a hint which can be used to ask the DB to not lock the tables during queries and then to read un-commited/dirty data. This command is like select count(*) from MyTable nolock in MySQL, I found that I can