jenthuz ojs
asked on
Create a stored procedure to insert 1 million entries random values
I need to Create a stored procedure to insert 1 million entries into my table tbl_student and execute it.
Columns:
These are the attributes, but the entries shouldn't be equal. I must insert random values. I need code for this.
Columns:
int_enrollment_no(int),
pk_int_roll_no(int primarykey),
vchr_name(varchar),
vchr_city(varchar),
vchr_mobileno(varchar),
dat_dob(date)These are the attributes, but the entries shouldn't be equal. I must insert random values. I need code for this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.