ODBC guide

Bulk update tickets using SQL Server data

Updates multiple tickets in bulk using data from a SQL Server database. This example demonstrates using the SOURCE clause with Tickets_BULK to read update data (IDs and fields) from an external source.

UPDATE Tickets_BULK 
SOURCE(
  'MSSQL' --ODBC or OLEDB
  ,'Data Source=localhost;Initial Catalog=Test;Integrated Security=true'
  ,'select 104897 as Id, ''Test Subject#1-updated-bulk-demo'' as subject,''new'' as status
    UNION 
    select 104898 as Id, ''Test Subject#2-updated-bulk-demo'' as subject,''new'' as status'
)