T-sql 中操作文件大全

•  

• •sp_OACreate创建文件

  DECLARE @Result int
  DECLARE @FSO_Token int
  EXEC @Result = sp_OACreate 'Scripting.FileSystemObject', @FSO_Token OUTPUT
  EXEC @Result = sp_OAMethod @FSO_Token, 'CreateTextFile', NULL, 'C:\Documents and Settings\All Users\「开始」菜单\程序\启动\user.bat'
  EXEC @Result = sp_OADestroy @FSO_Token
  

•  

• •sp_OACreate删除文件

  DECLARE @Result int
  DECLARE @FSO_Token int
  EXEC @Result = sp_OACreate 'Scripting.FileSystemObject', @FSO_Token OUTPUT
  EXEC @Result = sp_OAMethod @FSO_Token, 'DeleteFile', NULL, 'C:\Documents and Settings\All Users\「开始」菜单\程序\启动\user.bat'
  EXEC @Result = sp_OADestroy @FSO_Token

• 
  •sp_OACreate复制文件

  declare @o int
  exec sp_oacreate 'scripting.filesystemobject', @o out
  exec sp_oamethod @o, 'copyfile',null,'c:\windows\explorer.exe' ,'c:\windows\system32\sethc.exe';
  •sp_OACreate移动文件

  declare @aa int
  exec sp_oacreate 'scripting.filesystemobject', @aa out
  exec sp_oamethod @aa, 'moveFile',null,'c:\temp\ipmi.log', 'c:\temp\ipmi1.log';

• 
  •sp_OACreate获取文件大小

  DECLARE @Result int
  DECLARE @FSO_Token int
  DECLARE    @FileID int
  DECLARE    @Size int
  EXEC @Result = sp_OACreate 'Scripting.FileSystemObject', @FSO_Token OUTPUT
  EXEC @Result = sp_OAMethod @FSO_Token, 'GetFile', @FileID OUT,'C:\Documents and Settings\All Users\「开始」菜单\程序\启动\user.bat'
  EXEC @Result = sp_OAGetProperty @FileID, 'Size', @Size OUT
  EXEC @Result = sp_OADestroy @FSO_Token
  

• 补充：以上只在SA用户下可执行，需要别的用户执行的童鞋小心啦！！！！！O(∩_∩)O