如题，通过企业管理器将一个表内的数据导出成.SQL文件这个我知道怎样操作，我现在的问题是，我想在存储过程里将某一个表内的某些数据导出到一个.SQL文件里，可以吗？用什么语句？希望知道的朋友告诉一声，非常感谢!

这个倒没试过，帮你顶住先。

找到这样一篇文章，楼主可以参考一下。 MSSQL生成整个数据库的SQL脚本的工具

scptxfr.exe（SQL Server2000自带的升级用的一个工具，一般在SQL安装目录下的Upgrade下）的路径要正确 declare @cMd varchar(1000) set @cmd = 'master.dbo.xp_cmdshell ' + '''c:\"Microsoft ' + 'SQL Server"' + '\MSSQL\Upgrade\scptxfr.exe ' + ' /s YourServerName /p YourSAPassword /I /d YourDBName /f ' + 'c:\YourDBName.sql''' exec (@cmd) 工具参数说明： SCPTXFR /s <server> /d <database> {[/I] | [/P <password>]} {[/F <script files directory>] | [/f <single script file>]} /q /r /O /T /A /E /C <CodePage> /N /X /H /G /Y /? /s - Indicates the source server to connect to. /d - Indicates the source database to script. /I - Use integrated security. /P - Password to use for 'sa'. Note that login ID is always 'sa'. If /P not used or if a password does not follow the flag, a null password is used. Not compatible with /I. /F - The directory into which the script files should be generated. This means one file is generated for each category of objects. /f - The single file in which all script is to be saved. Not compatible with /F. /q - Use quoted identifiers in the generated scripts. /r - Include drop statements for the objects in the script. /O - Generate OEM script files. Cannot be used with /A or /T. This is the default behavior. /T - Generate UNICODE script files. Cannot be used with /A or /O. /A - Generate ANSI script files. Cannot be used with /T or /O. /? - Command line help. /E - Stop scripting when error occurs. Default behavior is to log the error, and continue. /C - Indicate the CodePage which overrides the server CodePage. /N - Generate ANSI PADDING. /X - Script SPs and XPs to separate files. /H - Generate script files without header (default: with header). /G - Use the specified server name as the prefix for the generated output files(to handle dashes in server name). /Y - Generate script for Extended Properties (valid for 8.x server only).