通过xp_cmdshell获取文件内容 [英] Get file contents via xp_cmdshell

问题描述

有从Windows xp命令提示符获取文件的方法吗？我试图运行 xp_cmdshell'类型[文件路径]'但然后当我将其他文件，并将其重命名为file.exe（即可执行）不行。

Is there way to get file from windows xp command prompt? I tried to run xp_cmdshell 'type [path to file]' but then when i insert theese data into other file and renaming it to file.exe (that is executable) it does not work. Any suggestions how to get file contents in such way that i can use it?

推荐答案

您可以对文件使用BULK INSERT，将该文件视为具有一行和一列的表。这应该允许你直接读取文件到一个VARBINARY字段

像这样：

You could use BULK INSERT on the file and treat the file as a table with one row and one column. This should allow you to read the file directly into a VARBINARY field

Like this:

CREATE TABLE FileRead
(
  content VARBINARY(MAX)
)

BULK INSERT FileRead FROM [FilePath]

这需要SQL Server访问您尝试读取的文件。听起来你正在试图从你无法访问的服务器获取可执行文件？ ： - ）

This requires SQL Server to have access to the file you are trying to read. It sounds like you are trying to "acquire" executables from a server you do not have access to? :-)

这篇关于通过xp_cmdshell获取文件内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！