Get the last modification date of the Operating System File in SQL Server [Z]

Source: Internet
Author: User
/*
Get the last object access date
@ Filepath: file path, for example, C: \ 1.txt
@ Filedate: Last file access date

Call example:
Declare @ DT varchar (20)
Exec getfilelastaccessdate 'C: \ 1.txt ', @ DT output
Select @ dt
*/
Create Procedure Getfilelastaccessdate
@ Filepath Varchar ( 4000 ),
@ Filedate Varchar ( 20 ) Output
As
Declare @ OBJ Int , @ File Int
Declare @ Fileexists Varchar ( 10 )
Exec Sp_oacreate ' Scripting. FileSystemObject ' , @ OBJ Output
Exec Sp_oamethod @ OBJ , ' Fileexists ' , @ Fileexists Output, @ Filepath
If @ Fileexists = ' False '
Begin
Set @ Filedate = ' File does not exist '
Return
End
Exec Sp_oamethod @ OBJ , ' GetFile ' , @ File Output, @ Filepath
Exec Sp_oagetproperty @ File , ' Datelastaccessed ' , @ Filedate Output
Go
/*
Get the last file modification date
@ Filepath: file path, for example, C: \ 1.txt
@ Filedate: last modification date of the file

Call example:
Declare @ DT varchar (20)
Exec getfilelastmodified 'C: \ 1.txt ', @ DT output
Select @ dt
*/
Create   Procedure Getfilelastmodified
@ Filepath   Varchar ( 4000 ),
@ Filedate   Varchar ( 20 ) Output
As
Declare @ OBJ Int , @ File Int
Declare @ Fileexists Varchar ( 10 )
Exec Sp_oacreate ' Scripting. FileSystemObject ' , @ OBJ Output
Exec Sp_oamethod @ OBJ , ' Fileexists ' , @ Fileexists Output, @ Filepath
If @ Fileexists = ' False '
Begin
Set @ Filedate = ' File does not exist '
Return
End
Exec Sp_oamethod @ OBJ , ' GetFile ' , @ File Output, @ Filepath
Exec Sp_oagetproperty @ File , ' Datelastmodified ' , @ Filedate Output
Go

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.