-
-
•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
T-sql 中操作文件大全
最新推荐文章于 2022-11-15 13:48:54 发布