温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:X3BLOG多用户博客 0.7.5.2源代码
当前文件:
X3Blog07/database/p_setUserPassword.sql,打开代码结构图
X3Blog07/database/p_setUserPassword.sql,打开代码结构图1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_setUserPassword]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 2
drop procedure [dbo].[p_setUserPassword] 3
GO 4
5
create procedure [dbo].[p_setUserPassword] 6
@user varchar(20), 7
@old char(40), 8
@pwd char(40) 9
as 10
11
UPDATE [user] SET pwd=@pwd WHERE account=@user AND pwd=@old 12
13
GO


