一、把数据库把某个字段更新为随机数
DECLARE @Hour INT DECLARE @Counts INT SET @Hour =DATENAME(HOUR, GETDATE()) IF (@Hour>=0 AND @Hour<7) BEGIN SET @Counts=ROUND((2 * RAND() + 1), 0) END ELSE IF (@Hour>=7 AND @Hour<8) BEGIN SET @Counts=ROUND((4 * RAND() + 4), 0) END ELSE IF (@Hour>=8 AND @Hour<11) BEGIN SET @Counts=ROUND((9 * RAND() + 19), 0) END ELSE IF (@Hour>=11 AND @Hour<13) BEGIN SET @Counts=ROUND((9 * RAND() + 9), 0) END ELSE IF (@Hour>=13 AND @Hour<=17) BEGIN SET @Counts=ROUND((9 * RAND() + 19), 0) END ELSE IF (@Hour>=18 AND @Hour<21) BEGIN SET @Counts=ROUND((9 * RAND() + 9), 0) END ELSE IF (@Hour>=21 AND @Hour<24) BEGIN SET @Counts=ROUND((4 * RAND() + 4), 0) END UPDATE dbo.t_Config SET Value=Value+@Counts
2、自定义随机函数
CREATE FUNCTION RoundNum(@Lower INT,@Upper INT) RETURNS INT AS BEGIN DECLARE @Result INT SELECT @Result = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0) RETURN( @Result) END GO
如果本文引用了你的文章而未注明,请及时联系我。