Waiting while executing query in SQL Server

-- Example using adventurework database

WAITFOR DELAY '00:00:10'
 BEGIN
     SELECT
         p.ProductID,
         p.Name
     FROM Production.Product AS p
 END