Ms SQL SERVER image or big text input and output

Source: Internet
Author: User
There is an executable file named TEXTCOPY. EXE in the ms SQL SERVER installation directory.
You can input and output text or image data in ms SQL SERVER.
But you can execute textcopy/in MS-DOS mode /? Get its description.

The following describes the tool:
Copies a single text or image value into or out of SQL Server. The val
Ue
Is a specified text or image 'column' of a single row (specified by th
E
"Where clause") of the specified 'table '.
If the direction is IN (/I) then the data from the specified 'file' is
Copied into SQL Server, replacing the existing text or image value. If
The
Direction is OUT (/O) then the text or image value is copied from
SQL Server into the specified 'file', replacing any existing file.
TEXTCOPY [/S] [sqlserver] [/U [login] [/P] [password]
[/D] [database] [/T table] [/C column] [/W "where clause"]
[/F file] [{/I |/O}] [/K chunksize] [/Z] [/?]
/S sqlserver The SQL Server to connect to. If 'sqlserver 'is n
Ot
Specified, the local SQL Server is used.
/U login The login to connect with. If 'login' is not spec
Ified,
A trusted connection will be used.
/P password The password for 'login'. If 'password' is not
Specified, a NULL password will be used.
/D database The database that contains the table with the tex
T or
Image data. If 'database' is not specified, the d
Efault
Database of 'login' is used.
/T table The table that contains the text or image value.
/C column The text or image column of 'table '.
/W "where clause" A complete where clause (including the WHERE keyw
Ord)
That specifies a single row of 'table '.
/F file The file name.
/I Copy text or image value into SQL Server from 'Fi
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.