WAITFOR

-- Do Something

WAITFOR DELAY '00:00:02';

-- Do Something after 2 seconds delay

Sources:

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/waitfor-transact-sql?view=sql-server-ver15