Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2013-02-18 : 06:42:59
|
Is it possible to identify the Image(*.jpg) mode (Landscape/Portrait)which i've stored in Hardrive (d:\images\) through T-sql Statement? |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-18 : 07:51:22
|
There is no native T-SQL statements that I am aware of that will enable you to do this. If you want to do this from within a T-SQL query, the only options I can think of are via a CLR stored procedure or via a executing a system command using xp_cmdshell. The code (written in .Net language if you want to use CLR stored proc) would need to examine the EXIF information from the JPG file to figure it out. |
|
|
|
|
|