IF EXISTS(SELECT * FROM sys.procedures WHERE name=‘usp_wait30s‘)
BEGIN
DROP PROC usp_wait30s
END
go
create PROC usp_wait30s
AS
BEGIN
PRINT CONVERT(VARCHAR(20),GetDate(),120)
WAITFOR delay ‘00:00:05‘
PRINT CONVERT(VARCHAR(20),GetDate(),120)
END
go
原文：http://www.cnblogs.com/KingUp/p/5722440.html