如何通过存储过程调用网页 [英] how to call a web page through stored procedure

问题描述

我想通过存储过程调用url.我该怎么办?

I want to call an url through Stored procedure. how can i do it?

推荐答案

您可能不想听这条建议，但是在这里却行得通:不要这样做.存储过程应在SQL Server上处理数据及其处理.在存储过程中从网站检索远程数据会引发各种麻烦:性能，事务争用，不确定性等.如果您绝对需要一些外部数据，请事先获取它们并将其传递给调用中的SP.您正在制作.

我的两分钱！

问候，

曼弗雷德(Manfred)

You may not want to hear this advice, but here it goes nevertheless: Don''t do this. Stored procedures should handle data and the processing thereof on the SQL Server. Retrieving remote data from a website in a store procedure is calling for all kinds of trouble: Performance, Transaction contention, Non-Determinism etc.. If you absolutely need some external data, fetch it beforehand and pass it along to the SP in the call you are making.

My two cents!

Regards,

Manfred

请参考一些类似的讨论:

从存储过程中发送URL请求 [ ^ ]
从存储过程中调用URL [ ^ ]
如何在tsql存储过程中执行url [

Please refer some similar discussions:

Send a URL request from a stored procedure[^]
Calling a URL from a stored procedure[^]
How to execute a url in tsql stored procedure[^]

尝试以下操作:

Try this:

exec master..xp_cmdshell 'c:\progra~1\intern~1\iexplore.exe www.xyz.com'

根据计算机设置将路径更改为iexplore.exe

Change the path to iexplore.exe as per your machine setup

这篇关于如何通过存储过程调用网页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！