USE AdventureWorks 
GO

SELECT @@SPID AS [Windows 2 SPID] 
GO

BEGIN TRANSACTION 

SELECT * FROM Production.Product WITH (UPDLOCK) -- Results Returned immediately 

WAITFOR DELAY '000:00:03'

SELECT * FROM Sales.Customer WITH (UPDLOCK) -- Results Not Returned Immediately 

ROLLBACK TRANSACTION 
GO