Sql延时

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

posted @ 2016-07-31 10:11  飘....  阅读(186)  评论(0编辑  收藏  举报