每2或3天后，存储过程表现异常。 [英] Store procedure behave abnormally after each 2 or 3 days .

问题描述

嗨朋友们，

我在我的数据库中有一个存储过程，为我创建了一个独特的代码。从过去1年起它工作正常，但从最近2周开始，每次显示异常错误2或3天。转换的事情是它在删除并重新创建具有相同代码的过程后再次开始正常工作（错误： - 无法将字符串转换为int）。请帮我解决。程序如下：

Hi Friends ,
I have a store procedure in my DB that create a unique code for me.It was working fine from last 1 year , but from last 2 week , showing unusual error after each 2 or 3 days .Strange thing is that it again start working fine after dropping and recreating procedure with same code (Error:-Failed to convert string to int).Please help me solve it .Procedure is given below

CREATE procedure [dbo].[select_purdrscode]
(@branchid int) as begin
SET NOCOUNT ON
if exists(select 1  from purdrs where branchid=@branchid)
begin
select top 1
b.branchcode +replace(CONVERT(VARCHAR(30),dateadd (minute, 330,getutcdate()),105),'-','')
+ cast((cast((REPLACE( d.drscode, left(d.drscode,11), '' ))as int)+1)as varchar(200))
 as drscode
 from PURdrs d inner join branch b
on b.branchid=d.branchid where d.branchid=@branchid
order by d.drsid desc
end
else
begin
select top 1
branchcode+replace(CONVERT(VARCHAR(30),dateadd (minute, 330,getutcdate()),105),'-','')
+'1' as drscode
 from branch   where branchid=@branchid
end
end

谢谢你

Thank You

推荐答案

它意味着你有一些破坏sql的数据。您需要调试它，因为我们无法访问您的数据库。

It means you have some data that is breaking the sql. You'll need to debug it since we do not have access to your database.

这篇关于每2或3天后，存储过程表现异常。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！