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-15 : 00:00:03
|
| HiIs it possible to identify the Image(*.jpg) mode (Landscape/Portrait)which i've stored in Hardrive (d:\images\) through T-sql Statement? |
|
|
Mar
Starting Member
47 Posts |
Posted - 2013-02-19 : 09:07:40
|
| T-SQL is for working with fields and tables. To get the orientation of the picture you would have to read the file using a language that supports file reads.So to answer your question, not really.You can:1) Add a field to the table and maybe update that field by the code that adds the image directory.2) Write a CLR stored procedure that returns the information based on a passed in path. You can then call this sp the the SQL statement. I wouldn't want to run it on a large recordset due to possible performance problems. |
 |
|
|
|
|
|
Image Mode