SQL Query Pause

[ilearneditonline]

I have 2 insert statements that I have to run at the end of a stored procedure.

But I need to pause for 5 seconds between the first and the second. Is there any way to do this?

[ck9663]

I have 2 insert statements that I have to run at the end of a stored procedure.

But I need to pause for 5 seconds between the first and the second. Is there any way to do this?

try the WAITFOR command

WAITFOR 
{
    DELAY 'time_to_pass' 
  | TIME 'time_to_execute' 
  | ( receive_statement ) [ , TIMEOUT timeout ]
}

[ilearneditonline]

try the WAITFOR command

WAITFOR 
{
DELAY 'time_to_pass' 
| TIME 'time_to_execute' 
| ( receive_statement ) [ , TIMEOUT timeout ]
}

Great. This fixed my issue. Anyone else looking at this, the MS LINK