TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jes Sie
737
1.2k
284.4k
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.
INSERT
INTO
[dbo].[tblVehicleType2]
([ChassisNumber])
SELECT
FLOOR(RAND() * POWER(
CAST
(10
as
BIGINT
), 9))
Any help is hightly appreciated. Thanks in advance.
Reply
Answers (
3
)
Regex Password for 8 chars
custom authorization mvc