We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Append the XML buffer to a temporary table, adding rows without recreating the table
Reads the current XML document (mdoc) and appends each record as a new row in the specified temporary table. Use this to accumulate rows across multiple XML loads into a single table. The table name must include $tempdb$ or the table is created in the main database. The first record must contain all fields. Field names are taken from XML element tags.
| Parameter | Description |
|---|---|
| cmd | TableName (the target temp table, must include $tempdb$) |
| Argument 0 | Flag to untag fields (1 to strip tag encoding from field names) |
| Argument 1 | Flag to ignore v6 legacy flag fields A and B (1 to skip them) |
| Argument 2 | Optional comma-separated field list; leave blank to use all fields |
XmlToTempTableAppend "TableName (the target temp table, must include $tempdb$)", "Flag to untag fields (1 to strip tag encoding from field names)", "Flag to ignore v6 legacy flag fields A and B (1 to skip them)", "Optional comma-separated field list; leave blank to use all fields"