Bulk Insert

• jucha

  SSC Veteran

  Points: 208

  More actions

  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.

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  February 3, 2008 at 11:41 am

  #774593

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

  INSERTMyTable

  SELECT'C2100',

  'LG',

  'TV'

  UPDATEMyTable

  SETCol1 = 'C2100',

  Col2 = 'LG',

  Col3 = 'TV'

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

  ---

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