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
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
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