ALTER PROCEDURE [AddInfor]@ID int OUTPUT,@classid INT,@checkurl NVARCHAR(50),@headmanpwd NVARCHAR(50),@supervisorpwd NVARCHAR(50),@testpaperurl NVARCHAR(50),@wrongtimes INTASBEGIN SET NOCOUNT ON DECLARE @Err int INSERT INTO TB_TestpaperDownload ( ClassID, CheckUrl, HeadmanPassword, SupervisorPas... Read More
posted @ 2013-05-22 10:10 梦醒心晴 Views(321) Comments(0) Diggs(0)
ALTER PROCEDURE Addwrongtimes@ID INT,@count INT OUTASBEGINSET @count = (SELECT wrongtimes FROM TB_TestpaperDownload WHERE ID=@ID)SET @count = @count+1UPDATE TB_TestpaperDownload SET WrongTimes=@count WHERE ID=@IDEND GO Read More
posted @ 2013-05-22 10:08 梦醒心晴 Views(207) Comments(0) Diggs(0)