|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Yesterday @ 9:26 AM
Points: 475,
Visits: 1,690
|
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, June 14, 2013 7:11 AM
Points: 94,
Visits: 1,360
|
|
This link may be helpful here:
http://www.simple-talk.com/code/OLEvsCLR/xp_getfiledetails.txt
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Saturday, September 15, 2012 7:21 AM
Points: 11,
Visits: 59
|
|
I agree with the SSC Rookie's post. sp_OAGetProperty is very soon to get deprecated. We shall replace such codes with CLR functions.
Thanks for the article though.
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111,
Visits: 27,037
|
|
SQLKnight (6/17/2010) I agree with the SSC Rookie's post. sp_OAGetProperty is very soon to get deprecated. We shall replace such codes with CLR functions.
Thanks for the article though.
Heh... Microsoft continues to shoot people in the face with their deprecation policy.
--Jeff Moden "RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|