Posted by laurenq uantrell on 09/18/05 00:04

Is it possible to use With (NOLOCK) and With (READPAST) in the same
SELECT query and what whould be the syntax?

@param int

SELECT
myRow
FROM
dbo.myTable WITH (NOLOCK)
WHERE
myRow = @param

Thanks,
lq

• Next in forum: Re: oracle pl/sql -> sql server
• Prev in forum: Re: Determine fastest query in Query Analyzer
• Thread view: NOLOCK and READPAST on same table?

[Reply to this message]