Post reply

Creating Stored Procedures for Updating the Value

  • December 15, 2011 at 1:57 am

    #149771

    Hi All,

    I am updating my excel data values in to SQL DB. Excel sheet having thousands of Records.

    When some data in Excel sheet is modifed, i want that data should be Updated in My DB Table.

    So for this issue, Can i use Stored Procedure ??

    Thanks

    sathish

  • December 15, 2011 at 3:24 am

    #1421806

    Means, you already updated the records, which are having in excel. Now some the records in excel are updated. U need that updated records in to SQL Db.

    Is it correct...

    Yes you can use Procedure to Update the Records which are modified in Excel.

    If exists Update 'Statement'

    If it is wrong please explain me more about the prob...:-)

    Skase:-):-)

  • December 15, 2011 at 3:43 am

    #1421811

    Hi,

    you are absolutely right.

    Previously i have some values in DB Table, so when new values are updated in Excel Sheet, will that new value will be populated in DB Table without affecting the record count ah ???

  • December 15, 2011 at 5:34 am

    #1421853

    First Time How You inserted the Data From Excel Sheet..?

  • December 15, 2011 at 5:43 am

    #1421857

    Hi,

    I am inserting the data through Java Source file, which calls the Inserting Function.

    thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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