Post reply

Bulk Insert

  • February 3, 2008 at 10:15 am

    #69556

    Hello.

    This line works fine.

    MyTable has 3 columns

    exec (insert MyTable SELECT 'C2100', 'LG', 'TV') and so on.

    But there similiar lines for udates? like

    update MyTable values (SELECT 'C2100', 'LG', 'TV')

    Please suggestion.

  • February 3, 2008 at 11:41 am

    #774593

    You do not need the EXEC thingy for each and one statement.

    INSERT MyTable

    SELECT 'C2100',

    'LG',

    'TV'

    UPDATE MyTable

    SET Col1 = 'C2100',

    Col2 = 'LG',

    Col3 = 'TV'

    WHERE SomeOtherCol = SomeValue -- To only update the record(s) satisfying the filter.

    N 56°04'39.16"
    E 12°55'05.25"

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

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