Queries for UPDLOCK Table Hint

1. Usage of UPDLOCK table hint (to be used in transaction)

SQL Server Query 1

            
 BEGIN TRANSACTION;  

 SELECT OrderID, CustomerID  

 FROM Orders WITH (UPDLOCK, READPAST, ROWLOCK) -- Will try to acquire a U lock  

 WHERE ShippedDate IS NULL  

 ORDER BY OrderDate ASC, OrderID ASC;  

 COMMIT TRANSACTION;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("OrderID","CustomerID")  

     .From("Orders", new List<IHint>() { new UPDLOCK(), new READPAST(), new ROWLOCK() })  

     .Where(new Where(new IS_NULL(new Column("ShippedDate"))))  

     .OrderBy(new OrderBy().SetColumnAscending("OrderDate")  

         .SetColumnAscending("OrderID"))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT OrderID,
       CustomerID
FROM Orders WITH (UPDLOCK, READPAST, ROWLOCK)
WHERE ShippedDate IS NULL
ORDER BY OrderDate ASC, OrderID ASC;


            
        

Parameters (If used)

Query Results 1: