Click here to Skip to main content
15,896,111 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
My problem is auto populating Table. I have table with 1000 record in it, but for testing purpose, i need to insert more data.

SQL
ID | PersonID | Date | Time | Sum | TypeID | PlaceID | StatusID

So i need to populate the database with 10000 records where the date is between 1/3/2015 and 1/5/2015, Time is Random, SUM Between 100 and 1000, TypeID between 1 and 2, PlaceID between 1-10, StatusID between 1-3

I would a appreciate any kind of help or suggestion.

Thanks in advance.
Posted
Updated 17-May-15 4:49am
v2
Comments
Sergey Alexandrovich Kryukov 17-May-15 10:49am    
Not a question. What have you tried so far?
—SA

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900