on 2019 Dec 08 5:10 AM
CREATE TABLE test ( filename VARCHAR(255) , f_updatefiles long binary );
The column name is f_updatefiles, which is used to store some common upgrade files (such as D ll files) of LL. I want to use SQL statements to export them to the server directory, but if I use
'select f_updatefiles from' DBA '. Test'; output to 😧 \\ 1.dll'
this file will report an error
The out put function can't use binary export file. The default is TXT. How to solve this problem
I recommend the xp_write_file() function to export files, both for text and binary files.
The OUTPUT command and the UNLOAD statement are primarily meant to export result sets to files.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.