ALTER PROCEDURE [dbo].[Pro_AuditProduct](
@id int
)
as
begin
update tg_teams set statue=1 where id=@id;
end
我想实现 当statue=1时将statue更新成0 当它等于0时将statue状态更新成1
这个存储过程怎么改呢
@id int
)
as
begin
update tg_teams set statue=1 where id=@id;
end
我想实现 当statue=1时将statue更新成0 当它等于0时将statue状态更新成1
这个存储过程怎么改呢
错了 应该是这个
@id int
)
as
begin
update tg_teams set statue=1-statue where id=@id;
end
ALTER PROCEDURE [dbo].[Pro_AuditProduct](
@id int
)
as
begin
declare @statue int
select @statue=statue from tg_teams where id=@id
if @statue=0
update tg_teams set statue=1 where id=@id;
if @statue=1
update tg_teams set statue=0 where id=@id;end