how to delay stored procedure execution in sql server for 3 seconds code example

Example: how to delay stored procedure execution in sql server

How to delay the execution of the stored procedure in SQL SERVER
The code below will delay the execution for 2hrs.

BEGIN  
    WAITFOR DELAY '02:00';  
    EXECUTE sp_helpdb;  
END;  
GO