USE Adventureworks 
GO

SELECT @@SPID AS [Windows 1 SPID] 
GO

BEGIN TRANSACTION 


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

WAITFOR DELAY '000:00:03'

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

ROLLBACK TRANSACTION
GO