Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Date Time Column (12:00:00 AM)

    should it not at least return

     2004/Jan/10 00:00:00 AM

    No, there is no 00:00:00 AM.  In AM/PM format times go from 01:00:00 to 12:59:59.  Depending on whether you meant 12 noon...

  • RE: Bringing Operating System File Information into SQL

     EXEC master..xp_dirtree 'c:\mydir', 1, 1

    xp_dirtree is not documented in on-line help, but it does work.  Param 2 affects the search depth so 1 = current dir.  It returns files and...

Viewing 2 posts - 1 through 2 (of 2 total)