• Hi Riya, its better if you keep of your old data in some temp table and then insert the new data....

    first insert the old data into a temp table then truncate old table and insert new ones into that....

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/