Forums - C# Corner

Forum guidelines
Hold On

Hold On

  • 1.2k
  • 622
  • 52.6k

Insert Random Number To Table Every 30 Days

Oct 9 2018 11:51 PM
Hello DBA's, I need your assistance. I need to insert a random numbers (9 numbers) to my table every 30 days. I have a query to generate the random numbers but I don't know how to insert it every 30 days.
  1. INSERT INTO [dbo].[tblVehicleType2]  
  2.            ([ChassisNumber])  
  3.        SELECT FLOOR(RAND() * POWER(CAST(10 as BIGINT), 9))  
Any help is hightly appreciated. Thanks in advance. 

Answers (3)