28,391
社区成员
发帖
与我相关
我的任务
分享
Set MyComm = Server.CreateObject("ADODB.Command")
MyComm.ActiveConnection = ConnStr
MyComm.CommandText = "Update_User_History"
MyComm.CommandType = 4 '
MyComm.Prepared = true
MyComm.Parameters.append MyComm.CreateParameter("@ExerciseEnd",2,1,4,ExerciseID)
MyComm.Parameters.append MyComm.CreateParameter("@ID",2,1,4,User_History_ID)
MyComm.Execute
if MyComm.Parameters(0)= 1 then
response.write ("<script language='javascript'>alert('成功');</script>")
else
response.write ("<script language='javascript'>alert('错误');</script>")
end if
USE [MS_Training]
GO
/****** 对象: StoredProcedure [dbo].[Update_User_History] 脚本日期: 11/18/2010 20:50:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Update_User_History]
-- Add the parameters for the stored procedure here
@ID int,
@ExerciseEnd int
AS
set nocount on
begin
BEGIN TRANSACTION
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
-- Insert statements for procedure here
UPDATE [MS_Training].[dbo].[User_History]
SET [ExerciseEnd]= @ExerciseEnd
WHERE
( [ID] = @ID)
IF @@error=0
begin
COMMIT TRANSACTION
return 1
end
ELSE
begin
ROLLBACK TRANSACTION
return 0
end
return
end