Post reply

sql statement for pulling time from external file

  • April 7, 2003 at 1:31 pm

    #63275

    When you right click on a file in windows explorer and go to properties you can get the size and the time. DocsOpen is a program that is accessing a sql database. It is pulling the time and size from the file it is referencing (just like if you do it through properties)and not pulling the time from the sql table. I was wandering what sql statement it is using to do this. Thanks in advance.

  • April 7, 2003 at 2:18 pm

    #453401

    To really know what's your app is running in SQL you should trace your server with profiler or with sp_trace* stored procedures. Anyway, maybe you want find out how is your app is getting the time of the file because it can be capturing the time with the code in wich your app is written and then passes that value to SQL in a select clause.

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

You must be logged in to reply to this topic. Login to reply