USE[magazinedb]
GO
/****** Object:  StoredProcedure [dbo].[Update_MagazineInformation_HZJ]    Script Date: 11/25/2010 10:25:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--更新杂志信息
createprocedure[dbo].[Update_MagazineInformation_HZJ]
(
@TabNamevarchar(20),
@TypeIDdecimal,
@TypeNamevarchar(20),
@TypeRemarkvarchar(100),
@TypeDatedatetime
)
as
begin
exec('
update '+@TabName+' set [name]='''+@TypeName+''',Remark='''+@TypeRemark+''',Date='''+@TypeDate+'''
where ID='''+@TypeID+'''
')
end
GO
/****** Object:  StoredProcedure [dbo].[UP_UserLogin_userPwd_LX]    Script Date: 11/25/2010 10:25:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATEPROCEDURE[dbo].[UP_UserLogin_userPwd_LX]
@loginIdDECIMAL,
@oldUserPwdVARCHAR(60),
@newUserPwdVARCHAR(60),
@resultINT OUTPUT
AS
BEGIN
DECLARE@pwdVARCHAR(60)
SELECT@pwd= userPwd FROM magazineDB..UserLogin WHERE loginId =@loginId
IF@pwd<>@oldUserPwd
SET@result=0
ELSE
BEGIN
UPDATE magazineDB..UserLogin SET userPwd =@newUserPwdWHERE loginId =@loginId
SET@result=1
END
END
GO
/****** Object:  StoredProcedure [dbo].[UP_UserLogin_SeekPwd_GW]    Script Date: 11/25/2010 10:25:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
createPROCEDURE[dbo].[UP_UserLogin_SeekPwd_GW]
@loginIdDECIMAL,    
@newUserPwdVARCHAR(60)    
AS
BEGIN
UPDATE magazineDB..UserLogin SET userPwd =@newUserPwdWHERE loginId =@loginId
END
GO
/****** Object:  StoredProcedure [dbo].[UP_user_readState_LX]    Script Date: 11/25/2010 10:25:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATEPROCEDURE[dbo].[UP_user_readState_LX]
@userIDDECIMAL,
@readStateVARCHAR(20)
AS
BEGIN
UPDATE magazineDB..[user]SET readState =@readStateWHERE userID =@userID
END
GO
。。。
。。。