for instance
select dbo.GetFileDateLastModified('c:\temp\test.txt');
egpotus,
2010-01-13 (first published: 2009-12-17)
for instance
select dbo.GetFileDateLastModified('c:\temp\test.txt');
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [GetFileDateLastModified] ( @FilePathAndName varchar(8000)) RETURNS datetime AS BEGIN DECLARE @FS int, @OLEResult int, @file_exists int, @DateLastModified datetime exec master.dbo.xp_fileexist @FilePathAndName,@file_exists OUTPUT IF @file_exists=1 BEGIN EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT IF @OLEResult <> 0 RETURN NULL EXEC @OLEResult = sp_OAMethod @FS, 'GetFile', @FS out,@FilePathAndName IF @OLEResult <> 0 RETURN NULL EXEC @OLEResult = sp_OAGetProperty @FS, 'DateLastModified', @DateLastModified OUT IF @OLEResult <> 0 RETURN NULL END ELSE RETURN NULL RETURN @DateLastModified END
2017-05-09 (first published: 2017-05-03)
1,675 reads
Function for splitting the values in string, applying logic and concatenating back to string.
2013-11-21 (first published: 2013-11-11)
2,410 reads
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,120 reads
After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.
2010-08-26 (first published: 2010-08-19)
1,786 reads
2010-01-11
9,878 reads