34,593
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID (N'sp_personal_userinfoUpdate09', N'P' ) IS not null
DROP PROCEDURE sp_personal_userinfoUpdate09;
GO
CREATE PROCEDURE sp_personal_userinfoUpdate09
(
@iUserRegId int
,@sUserTrueName varchar(50)
,@sNickName varchar(50)
,@sUserEmail varchar(50)
,@sMobile varchar(50)
,@sTel varchar(50)
,@sQq varchar(50)
,@sMsn varchar(50)
,@sBirthday varchar(50)
,@sRegion varchar(50)
,@sCity varchar(50)
,@sSelfIntro varchar(2000)
,@sWorkYn varchar(10)
,@sOpenInfoYn varchar(10)
,@sPhoto varchar(10)
,@iSex int
,@sSpecialty varchar(50)
,@sUserLoginName varchar(50)
)
WITH ENCRYPTION
AS
BEGIN
begin tran addandup
update tb_userRegInfo set fd_User_Name=@sUserTrueName,fd_nickName=@sNickName,fd_Email=@sUserEmail
,fd_mobile=@sMobile,fd_tel=@sTel,fd_qq=@sQq,fd_msn=@sMsn,fd_birthday=@sBirthday
,fd_region=@sRegion,fd_city=@sCity,fd_selfIntro=@sSelfIntro
,fd_workYn=@sWorkYn,fd_openInfoYn=@sOpenInfoYn,fd_photoFileName=@sPhoto
,fd_sex=@iSex,fd_Specialty=@sSpecialty
where fd_userRegId=@iUserRegId;
--同时修改学生表中的信息
update tb_Users set fd_User_Name=@sUserTrueName,fd_nickName=@sNickName,fd_Email=@sUserEmail
,fd_mobile=@sMobile,fd_tel=@sTel,fd_qq=@sQq,fd_msn=@sMsn,fd_birthday=@sBirthday
,fd_region=@sRegion,fd_city=@sCity,fd_selfIntro=@sSelfIntro
,fd_workYn=@sWorkYn,fd_openInfoYn=@sOpenInfoYn,fd_photoFileName=@sPhoto
,fd_sex=@iSex,fd_Specialty=@sSpecialty
where fd_Login_Name=@sUserLoginName
commit tran addandup
IF @@ERROR <> 0 or @@rowcount > 1
begin
rollback tran addandup
end
END
语句执行不了啊 改不了数据select * from #interm_report
#interm_report 代表是临时表