从wcf服务调用时，存储过程不起作用

问题描述

限时删除！！

我有一个存储过程，它基本上会根据作为参数传递给sp的字符串插入和更新，如果在SSMS中执行sp，sp工作正常，但是如果我使用WCF服务从SL5应用程序调用相同的sp，则返回我从sp传递的保存信息，但如果我通过sp查询表插入，则需要时间列出10列3列记录，而我需要花时间查询sp_who2，这表明select语句被阻塞了SPID，这是来自SL5应用程序，如何解决此问题并插入/更新freom UI

i have a stored procedure it will basically insert and update based on a string passed as parameter to sp, sp works fine if it is executed in SSMS, but if i invoke the same sp from SL5 application using WCF Service it returns the saved information which i pass from the sp, but if i query the table insert thru sp, it takes time to list 10 records with 3 columns, while it taking time i queried using sp_who2 which show the select statement is blocked a SPID, which was the one from SL5 Application, How to resolve this and insert / Update freom UI

推荐答案

这篇关于从wcf服务调用时，存储过程不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

1403页，肝出来的..