TSQL OLE (com) 对象
从 tsql 调用 ole 对象是否存在任何固有问题？ 我遇到了一个问题，我想仅使用存储过程来解决，与使用基于 clr 的语言编写它相比，使用 ole 对象是否需要担心什么？
Are there any inherent problems with calling an ole object from tsql? I have been posed with a problem that I would like to solve solely using a stored procedure, is there anything I need to worry about with using a ole object as opposed to writing it in a clr based language?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
首先确保您不能将其作为基于集合的操作来执行，记住完成后释放它们，并记住这根本不会是可移植的（但 clr 代码也不会）。
Just make sure you can't do it as a set-based operation first, remember to free them when you're done, and remember that this isn't going to be at all portable (but then neither would the clr code).
Com 对象主要是本机代码，如果您调用存在内存泄漏的内容，则可能会导致问题
Com objects are mostly native code, if you call something that has a memory leak you could cause problems down the road