本文介绍了记录未在存储过程中更新的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 我有存储程序--- 创建 proc [dbo]。[spUpdateEstmateDetail] ( @ FileCode varchar ( 50 ), @ WorkBriefName varchar ( 50 ), @ WorkDetailedName varchar ( 200 ), @ EstimationDate datetime , @ WID INT , @ MID INT , @ EstimatedQuantity float , @ Unit varchar ( 50 ), @ EstimatedAmount float , @ EstimateID INT , @ IsUpdated INT 输出 ) AS IF NOT EXISTS ( SELECT EstimateID FROM 估计 WHERE FileCode = @ FileCode) BEGIN print @ EstimateID 更新估算 SET FileCode = @ FileCode, WorkBriefName = @ WorkBriefName, WorkDetailedName = @ WorkDetailedName, EstimationDate = @ EstimationDate, WID = @ WID , MID = @ MID, EstimatedQuantity = @ EstimatedQuantity,单位=单位, EstimatedAmount = @ EstimatedAmount WHERE EstimateID = @ EstimateID print @ EstimateID SET @ IsUpdated = 1 END ELSE BEGIN SET @ IsUpdated = 2 - ---------------- ------ 和我的表 其中数据.... 。和希望 更新相关的记录 to table data coulumn 我的表 ...估计 EstimateID FileCode WorkBriefName WorkDetailedName EstimationDate EstimatedQuantity单位EstimatedAmount WID MID 43 f120 tryr rtee 2013-11-11 00:00:00。 000 12 1 215 1 1 45 f122 gt ytr 2013-01-02 00:00:00。 000 15 150 1500 31 2 44 f123 gtr ytr 2013-11-01 00:00:00。 000 121 13 1500 31 2 - ------------- 我怎么能调试 过程 其中 个错误所以这里查询 商店 procedure 执行成功...但不 update 记录如何 alter 在 SP中哪些是哪个?错误其中我受委屈 解决方案 请试试这个, 在storeprocedure上放置断点 选择exec storeprocedurename 然后点击Run Button not Execute I have store procedure ---Create proc [dbo].[spUpdateEstmateDetail](@FileCode varchar(50) ,@WorkBriefName varchar(50) ,@WorkDetailedName varchar(200) ,@EstimationDate datetime ,@WID INT ,@MID INT ,@EstimatedQuantity float ,@Unit varchar(50) ,@EstimatedAmount float ,@EstimateID INT ,@IsUpdated INT OUTPUT)ASIF NOT EXISTS(SELECT EstimateID FROM Estimate WHERE FileCode=@FileCode)BEGIN print @EstimateIDUPDATE EstimateSET FileCode=@FileCode,WorkBriefName=@WorkBriefName,WorkDetailedName=@WorkDetailedName,EstimationDate=@EstimationDate,WID=@WID,MID=@MID,EstimatedQuantity=@EstimatedQuantity,Unit=Unit,EstimatedAmount=@EstimatedAmountWHERE EstimateID=@EstimateIDprint @EstimateIDSET @IsUpdated=1ENDELSEBEGINSET @IsUpdated=2------------------------and my table where the data .....and want to update records related to table data coulumnMy table ... EstimateEstimateID FileCode WorkBriefName WorkDetailedName EstimationDate EstimatedQuantity Unit EstimatedAmount WID MID43 f120 tryr rtee 2013-11-11 00:00:00.000 12 1 215 1 145 f122 gt ytr 2013-01-02 00:00:00.000 15 150 1500 31 244 f123 gtr ytr 2013-11-01 00:00:00.000 121 13 1500 31 2---------------how can i debugged in the Store procedure that where is errorsSo here query of Store procedure execute successfully ...but not update the records so how can alter in SP which find the error where i am wronged 解决方案 Please try this,,place break-point on storeprocedure on topselect exec storeprocedurenamethen click Run Button not Execute 这篇关于记录未在存储过程中更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-04 06:24
查看更多