CREATE PROCEDURE usp_zjkj_zjkjdel
@id int
ASdeclare @a float
declare @b varchar(50)
select @a=paydeal from g_business_kj where id=@id
select @b=ridenumber from g_business_kj where id=@id
update g_business_zjsq set yf=yf-@a where ridenumber=@b
GO存储过程如上,在查询分析器中能执行但没有结果.请大家指点.
@id int
ASdeclare @a float
declare @b varchar(50)
select @a=paydeal from g_business_kj where id=@id
select @b=ridenumber from g_business_kj where id=@id
update g_business_zjsq set yf=yf-@a where ridenumber=@b
GO存储过程如上,在查询分析器中能执行但没有结果.请大家指点.
@id int
AS declare @a float
declare @b varchar(50)
select @a=paydeal from g_business_kj where id=@id
select @b=ridenumber from g_business_kj where id=@id
update g_business_zjsq set yf=yf-@a where ridenumber=@b select @a,@bGO
CREATE PROCEDURE usp_zjkj_zjkjdel
@id int
AS declare @a float
declare @b varchar(50)
select @a=paydeal from g_business_kj where id=@id
select @b=ridenumber from g_business_kj where id=@id
update g_business_zjsq set yf=yf-@a where ridenumber=@b
GO
--調用過程
EXEC usp_zjkj_zjkjdel 5