ALTER PROCEDURE [dbo].[Pavilion_UpdateUse]
@PId int
AS
declare @temp int
declare @sql varchar(1000)
begin
select @temp = [isuse] from [Pavilion] WHERE PId=@PId
if @temp=0
begin
set @sql = 'update [Pavilion] set [isuse]=1 WHERE PId='+RTRIM(@PId)
end
else
begin
set @sql = 'update [Pavilion] set [isuse]=0 WHERE PId='+RTRIM(@PId )
end
exec(@sql)
end
--红色转为字符再加
ALTER PROCEDURE [dbo].[Pavilion_UpdateUse]
@PId int
AS
declare @temp int
declare @sql varchar(1000)
begin
select @temp = [isuse] from [Pavilion] WHERE PId=@PId
if @temp=0
begin
set @sql = 'update [Pavilion] set [isuse]=1 WHERE PId='+@PId
end
else
begin
set @sql = 'update [Pavilion] set [isuse]=0 WHERE PId='+@PId
end
exec(@sql)
end