Read and write files in SQL scripts

Read and write files in SQL script first need to open xp_cmdshell

[SQL] sp_configure ' show advanced options ', 1  reconfigure  go  sp_configure ' xp_cmdshell ', 1  Reconfigure  Go  

And then insert in sql:

[SQL] Declare @Path varchar  Set @Path = ' E:\Test.txt '   Declare @Command varchar  Set @Command = ' echo ' Hello World Rex ">" + @Path  exec master. xp_cmdshell @Command   or [SQL] Declare @Path varchar  Set @Path = ' E:\Test.txt '   Declare @Command varchar  Set @Command = ' echo ' ' [email protected]<strong>myvarible</strong>+ ' "> ' + @Path  exec master. xp_cmdshell @Command  

　　

Article source: file read and write in SQL script

Read and write files in SQL scripts