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)

浙公网安备 33010602011771号