If you need to export or import data from the temporary table you can use the scripts described in this article.
Execute the script and adjust is based on the specifc matter setting that you want to apply.
Example based on a matter referred to as: M_0003.
@rem export from TempTable to export.out
bcp %queryOrTable% out export.out -N -T -S%sqlComputerName%
(It is faster and more reliable to use an export/import script file rather than SQL management studio)
The binary Data field is represented in ANSI format and can be searched for string values.
To import the contents of the file to a temp table you can use:
@rem import to tepmtable
bcp %tableNameToImportDataTo% in export.out -N -T -S%sqlComputerName%
- Please note that both scripts are using a trusted connection (-T)
- In order to get more information on bcp use bcp /?
- The Microsoft bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.
- The utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
Article is closed for comments.