1
ALTER PROCEDURE dbo.aspnet_Membership_SetPassword
2
@ApplicationName NVARCHAR(256),
3
@UserName NVARCHAR(256),
4
@NewPassword NVARCHAR(128),
5
@PasswordSalt NVARCHAR(128),
6
@TimeZoneAdjustment INT,
7
@PasswordFormat INT = 0
8
AS
9
BEGIN
10
DECLARE @UserId UNIQUEIDENTIFIER
11
SELECT @UserId = NULL
12
SELECT @UserId = u.UserId
13
FROM dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
14
WHERE LoweredUserName = LOWER(@UserName) AND
15
u.ApplicationId = a.ApplicationId AND
16
LOWER(@ApplicationName) = a.LoweredApplicationName AND
17
u.UserId = m.UserId
18
/*茶锈符合条件的用户ID*/
19
IF (@UserId IS NULL) --如果不存在,返回1
20
RETURN(1)
21
DECLARE @DateTimeNowUTC DATETIME --声明时间,获取时间(差不多就这意思吧-_-!)
22
EXEC dbo.aspnet_GetUtcDate @TimeZoneAdjustment, @DateTimeNowUTC OUTPUT
23![](/Images/OutliningIndicators/None.gif)
24
25
UPDATE dbo.aspnet_Membership
26
SET Password = @NewPassword, PasswordFormat = @PasswordFormat, PasswordSalt = @PasswordSalt,
27
LastPasswordChangedDate = @DateTimeNowUTC
28
WHERE @UserId = UserId
29
/*更新用户密码,返回0(这个改密码没前一个复杂,不清楚怎么要两个改密码的操作)*/
30
RETURN(0)
31
END
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)
29
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
30
![](/Images/OutliningIndicators/None.gif)
31
![](/Images/OutliningIndicators/None.gif)