I have to populate bulk data into Microsoft SQL Server(around 20,000 records in a table). For each fields in the table, I have to increment/randomly generate to populate it in the SQL Server. Basically, I am from Java background, I thought of writing it in java to populate. Since I don't much aware of syntax of PL/SQL, I have decided to do it in Java. My Question is: Is the PL/SQL will be easier than Java for this job? orSome other easy way is there provided by SQL Server itself.. Please give me some suggestion on it..
SCJP 1.4 (86%), SCWCD 1.4 (86%), SCBCD 1.3 (85%), SCDJWS (Just Started...) - Satisfaction Lies in Our EFFORT, Not in the ATTAINMENT
subject: To Populate Bulk Records in SQL Server thru Java