Post reply

how to manage insert update and delete operation in one procedure

  • August 5, 2010 at 1:15 am

    #225797

    Hii..

    how to manage insert update and delete operation in one procedure..

    Thanks.

  • August 5, 2010 at 4:19 am

    #1202605

    Though I work with the administration part most of the times,I do look at the queries that hit my databases.If there is a routine task that needs to be done,then I will prefer to have 3 different stored procedures for each of the tasks scheduled in off-peak hours.Also,please make sure that the execution plan shows the optimum plan that it will use(and if you find it best).In case,these queries will run all throughut the day,the make sure to keep an eye on Indexes and Statistics.

    Can you please be more clear if it is your OLTP application that will hit randomly or your scheduled tasks for some data loading or manipulation.A T-SQL guru here can answer you and guide you properly.:-P

  • August 5, 2010 at 4:37 am

    #1202613

    If you want to do insert, update and delete in one target table on the basis of joining results with other table then you can use MERGE operator of SQL Server 2008.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply