Delay response of query execution in sql server



BEGIN

   WAITFOR DELAY '00:00:05' -- Wait 5 seconds


   select * from table_name


   -- Break on some condition

END