|
Mar
Starting Member
23 Posts |
Posted - 02/19/2013 : 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. |
 |
|