(Dave Stokes) Last time we looked at SKIP LOCKED where rows locked by another process were skipped. NOWAIT informs the server to return immediately IF the desired rows can not be locked.
Read More (Community content)
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help