how to pause a stored procedure?

How do I pause a stored procedure X seconds?

Does any function exists like sleep in sybase to do this?


Thank you.

I believe it is "waitfor"

WAITFOR DELAY '000:00:xx'

waits xx seconds.