sqlserver每30分自动生成一次

来源：动视网责编：小采时间：2020-11-09 13:52:31

sqlserver每30分自动生成一次

sqlserver每30分自动生成一次:DECLARE @BeginTime AS DATETIME DECLARE @EndTime AS DATETIME DECLARE @Hour AS INT DECLARE @Min AS INT SET @Min = DATEPART(Minute, GETDATE()) IF @Min 30 BEGIN SET @BeginTime = CONVERT(VARCHAR(10), GETDATE(), 120) + ' ' + CAST(DATEPART(Hour,

推荐度：

点击下载本文 文档为doc格式

导读sqlserver每30分自动生成一次:DECLARE @BeginTime AS DATETIME DECLARE @EndTime AS DATETIME DECLARE @Hour AS INT DECLARE @Min AS INT SET @Min = DATEPART(Minute, GETDATE()) IF @Min 30 BEGIN SET @BeginTime = CONVERT(VARCHAR(10), GETDATE(), 120) + ' ' + CAST(DATEPART(Hour,

DECLARE @BeginTime AS DATETIME DECLARE @EndTime AS DATETIME DECLARE @Hour AS INT DECLARE @Min AS INT SET @Min = DATEPART(Minute, GETDATE()) IF @Min 30 BEGIN SET @BeginTime = CONVERT(VARCHAR(10), GETDATE(), 120) + ' ' + CAST(DATEPART(Hour,

　　DECLARE @BeginTime AS DATETIME

　　DECLARE @EndTime AS DATETIME

　　DECLARE @Hour AS INT

　　DECLARE @Min AS INT

　　SET @Min = DATEPART(Minute, GETDATE())

　　IF @Min < 30

　　BEGIN

　　SET @BeginTime = CONVERT(VARCHAR(10), GETDATE(), 120) + ' ' + CAST(DATEPART(Hour, GETDATE()) AS VARCHAR) + ':30'

　　SET @EndTime = CONVERT(VARCHAR(10), GETDATE(), 120) + ' ' + CAST(DATEPART(Hour, GETDATE()) AS VARCHAR) + ':00'

　　SET @BeginTime = DATEADD(Hour, -1, @BeginTime)

　　END

　　ELSE