ODBC guide

Bulk delete tickets using IDs from SQL Server

Deletes multiple tickets in bulk using IDs from a SQL Server database. This example demonstrates using the SOURCE clause with Tickets_BULK to read IDs from an external source for deletion.

DELETE FROM Tickets_BULK 
SOURCE(
  'MSSQL' --ODBC or OLEDB
  ,'Data Source=localhost;Initial Catalog=Test;Integrated Security=true'
  ,'select 104897 as Id 
    UNION 
    select 104898 as Id'
)