Post reply

How to get the file size stored in SQL Server?

  • June 20, 2007 at 10:59 am

    #68583

    I have a column defined as image. People save a file in this column. How to know the file size?

    Many thanks in advance.

  • June 20, 2007 at 1:51 pm

    #714207

    select DATALENGTH ( column )

    from [yourtable]

    where pkey = xyz


    * Noel

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

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