本文介绍了如何通过存储过程调用网页的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想通过存储过程调用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'
根据计算机设置将路径更改为iexplore.exe
Change the path to iexplore.exe as per your machine setup
更多推荐
如何通过存储过程调用网页
发布评论