I have a table which contains data for 12 months. Now i want to delete the data for the month of Aug, and insert new data which is present with me. For which i would do the following
delete from MyTable where Cdate between ('2012-08-01','2012-08-31')
Now my question is How to insert the new data into database. Is it like writing 31 insert statement?