Scheduled data insertion for SQL jobs

1. The following operations are performed to create a job in SQL Enterprise Manager:
Manage --> job --> right-click Create job --> step (create operation in, set operation time in scheduling)
2. the SQL statement for generating random numbers is as follows:
Insert magzinerandom (ID, randomnum, createtime)
Select newid (), (select top 1 num from numrandom order by newid (), convert (varchar (4), datepart (year, getdate ())) + '-' + convert (varchar (2), datepart (month, getdate () + '-' + convert (varchar (2), datepart (day, getdate ()))

After the preceding two steps, a random number can be automatically created every day ~

3. SQL yesterday Date:
Select dateadd (day,-1, getdate ())