反正有从SQL Server调用VB.net中的函数吗? [英] Is there anyway to invoke function in VB.net from SQL Server?

问题描述

大家好！
我想知道是否仍然可以直接从SQL Server调用VB中的函数.我已经在VB中开发了在不同客户端上运行的应用程序，但它们仅连接到一台服务器.因此，我所需要的是，当一个客户端向服务器发送任何数据时，另一客户端刷新以自动获取数据.

Hello all!!
I would like to know whether there is anyway we can invoke function in VB directly from SQL server.I have developed application in vb that run on different clients but they connected to one server only. So all I need is that when one client send any data to server, other client refresh to get data automatically.
Any help please?

推荐答案

否，您不能使用SQL Server功能从数据库上的客户端上调用函数.

为什么不这样做呢?客户端可以定期轮询数据库，以查看该客户端是否有数据.另一种可能性是使用 SqlDependency [

No you cannot invoke a function on the client from the database using SQL Server features.

Why not do it the other way around? The client can poll the database periodically to see if there is data for that client. Another possibility is to use SqlDependency[^]

这篇关于反正有从SQL Server调用VB.net中的函数吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！