SQL 随笔

自动生成10位ID

DECLARE @num INT DECLARE @strID NVARCHAR(20) SET @strID = '00000000000000000' + cast(@num AS NVARCHAR(10)) SET @strID = RIGHT(@strID, 10)

 

Date的运算

DECLARE @StartDate DATETIME SET @StartDate = dateadd(day, 5, GetDate()) --add day PRINT @StartDate SET @StartDate = dateadd(hh, 5, GetDate()) --add hour PRINT @StartDate

DATEADD() 函数在日期中添加或减去指定的时间间隔。DATEADD(datepart,number,date)

datepart 缩写年 yy, yyyy季度 qq, q月 mm, m年中的日 dy, y日 dd, d周 wk, ww星期 dw, w小时 hh分钟 mi, n秒 ss, s毫秒 ms微妙 mcs纳秒 ns

 

DECLARE @num INT DECLARE @strID NVARCHAR(20) --DELETE DELETE FROM [dbo].[Banner] SET @num = 0 WHILE @num < 10 BEGIN SET @strID = '00000000000000000' + cast(@num AS NVARCHAR(10)) SET @strID = RIGHT(@strID, 10) --print RIGHT( @strID,10) --INSERT INSERT INTO [dbo].[Banner] VALUES ( @strID ,@strID + '.jpg' ,'' ,'1' ,@num ,getdate() ,getdate() ,getdate() ,'false' ) SET @num = @num + 1 END View Code DECLARE @num INT DECLARE @strID NVARCHAR(20) DECLARE @StartDate DateTime --DELETE DELETE FROM [dbo].[Event] SET @num = 0 WHILE @num < 10 BEGIN SET @strID = '00000000000000000' + cast(@num AS NVARCHAR(10)) SET @strID = RIGHT(@strID, 10) --print RIGHT( @strID,10) SET @StartDate = dateadd(day,@num, GetDate()) --add day --print @StartDate --print dateadd(hh,1,getdate()) --add hour --INSERT INSERT INTO [dbo].[Event] VALUES (@strID ,'Title '+@strID ,'Description '+@strID ,@strID+'.jpg' ,@StartDate ,dateadd(hh,3,@StartDate) ,'Venue ' +@strID ,'1' ,'Creator' ,'' ,'20' ,GetDate() ,GetDate() ,GetDate() ,'false') SET @num = @num + 1 END View Code

 

转载于:https://www.cnblogs.com/xiaobuild/p/5085183.html

相关资源：JAVA上百实例源码以及开源项目