ALTER PROCEDURE Addwrongtimes @ID INT, @count INT OUT AS BEGIN SET @count = (SELECT wrongtimes FROM TB_TestpaperDownload WHERE ID=@ID) SET @count = @count+1 UPDATE TB_TestpaperDownload SET WrongTimes=@count WHERE ID=@ID END GO
ALTER PROCEDURE Addwrongtimes @ID INT, @count INT OUT AS BEGIN SET @count = (SELECT wrongtimes FROM TB_TestpaperDownload WHERE ID=@ID) SET @count = @count+1 UPDATE TB_TestpaperDownload SET WrongTimes=@count WHERE ID=@ID END GO