Can you determine size of tiff document (width & height)

• smacumber 77733

  Ten Centuries

  Points: 1288

  More actions

  June 25, 2012 at 9:27 am

  #392596

  In one of our SQL tables we store the size and location of an image (tif) is there a way to extract the size (width & height)?

  Thanks!

• GSquared

  SSC Guru

  Points: 260824

  More actions

  June 25, 2012 at 10:06 am

  #1505135

  When you say you store the size, I'm assuming you mean something other than width and height. File size maybe?

  If it's file size, then no, you can't calculate width and height from that.

  You could probably set up a .NET function that would pull the file metadata and the dimensions that way. No way to do so in T-SQL.

  Edit to fix typo.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon