不对啊
我的没有超过4000吧?
是如下:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER Proc DeleteCxm
As
Declare @gh Varchar(6)
Declare @rq Varchar(8)
Declare cxm Cursor For Select abm_gh,abm_rq From abm_mstr Where abm_zt In ('1','2')
Open cxm
Fetch Next From cxm Into @gh,@rq
While @@Fetch_Status=0
Begin
If Exists(Select * From cxm_mstr Where cxm_zt='4' And cxm_gh=@gh And cxm_rq=Convert(Smalldatetime,@rq))
Update abm_mstr Set abm_zt='3' Where abm_gh=@gh And abm_rq=@rq
Fetch Next From cxm Into @gh,@rq
End
Close cxm
Deallocate cxm
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
后我加密再解密就出现以上的了