在SQL 脚本中进行 文件的读写

首先需要开启xp_cmdshell

sp_configure 'show advanced options',1reconfiguregosp_configure 'xp_cmdshell',1reconfigurego

然后再SQL中插入：

Declare @Path varchar(5000)Set @Path='E:\Test.txt' declare @Command varchar(5000)set @Command='echo "Hello World Rex">' + @Pathexec master..xp_cmdshell @Command

或

Declare @Path varchar(5000)Set @Path='E:\Test.txt' declare @Command varchar(5000)set @Command='echo "'+@MyVarible+'">' + @Pathexec master..xp_cmdshell @Command