Код: Выделить всё
EXEC dbo.sp_addextendedproc N'xp_getexif', 'xp_getexif'
GO
GRANT EXECUTE ON xp_getexif TO public
GO
exec master..xp_getexif 'c:\Temp\DSCN0158GeoTag.jPg'
GOКод: Выделить всё
0 0 ---------------------------------------
271 Vendor NIKON
272 Model COOLPIX P6000
274 Orientation top - left
306 Date Time 2009:06:26 02:39:05
531 YCBCR_POSITIONING centered
1 1 ---------------------------------------
2 EXIF ---------------------------------------
33434 Exposure time 1/291 sec.
33437 F number f/5.7
34850 Exposure program Normal program
34855 Speed rating 64
36864 Exif version Exif Version 2.2
36867 Date Time Original 25/06/2009-11:01:01
36868 Date Time digitized 2009:06:25 11:37:02
37381 Max aperture value 2.90
37385 Flush Flash did not fire, compulsatory flash mode.
37386 Focal length 6.0 mm
37510 User comment
40960 Flush pix version FlashPix Version 1.0
40961 Color space sRGB
40962 Pixel X domention 4224
40963 Pixel Y domention 3168
41728 File source DSC
41986 Exposure mode Auto exposure
41987 White balance Auto white balance
41988 Digital zoom ratio 0.00
41989 Focal length 28
3 GPS ---------------------------------------
0 VERSION ID 0x02, 0x02, 0x00, 0x00
1 LATITUDE_REF N
2 LATITUDE 43.00, 28.00, 47.29
3 LONGITUDE_REF W
4 LONGITUDE 80.00, 32.00, 28.61
5 ALTITUDE_REF 0x00
4 Interoperability ---------------------------------------USE [master]
GO
Код: Выделить всё
EXEC dbo.sp_addextendedproc N'xp_getiptc', 'xp_getiptc'
GO
GRANT EXECUTE ON xp_getiptc TO public
GO
exec master..xp_getiptc 'c:\Temp\iptc.jpg'
GOКод: Выделить всё
80 by line color table85 by line title bars 2 panels120 caption IPTC color test122 caption editor John Petrov15 category CTG90 city Waterloo118 contact 116 copyright Photo Look101 country Canada55 creation date 11/09/2005110 credits Chart105 headline just a test130 imagetype 25 keywords mask,face,color,table135 language id 27 location 5 object name iptc color test131 orientation 4865 origin program 000000000000000050 origin trans ref Job Identifier115 photo source www.iptc.org70 program version 40 special instructions special test95 state ON20 subcategory Supplemental Categories,Life103 transref 10 urgency 2
