随笔分类 - Community Server 2.0 存储过程
对存储过程进行注释说明.因为本人也不太懂,所以本类里的文章主要是个人学习之用.目前对CSS也只是了解一点,数据库中也有很多字段不知道是什么意思.所以仅供参考.
aspnet_Membership_UpdateUserInfo
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_UpdateUserInfo 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256), 4 @IsPasswordCorrect ...
阅读全文
aspnet_Membership_UpdateUser --更新用户数据
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_UpdateUser --更新用户数据 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256), 4 @Email NVARCHAR(256), 5 @Comment...
阅读全文
aspnet_Membership_UpdateUser --更新用户数据
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_UpdateUser --更新用户数据 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256), 4 @Email NVARCHAR(256), 5 @Comment...
阅读全文
aspnet_Membership_UpdateLastLoginAndActivityDates --更新最近登陆和活跃时间
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_UpdateLastLoginAndActivityDates --更新最近登陆和活跃时间 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256), 4 @TimeZoneAdjustm...
阅读全文
aspnet_Membership_UnlockUser --解除锁定
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_UnlockUser --解除锁定 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256) 4AS 5BEGIN 6 DECL...
阅读全文
aspnet_Membership_SetPassword
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_SetPassword 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256), 4 @NewPassword NVARCHAR(128), 5 @PasswordSalt NVARCHAR(1...
阅读全文
aspnet_Membership_ResetPassword
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_ResetPassword 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256), 4 @NewPassword NVARCHAR(...
阅读全文
aspnet_Membership_GetUserByUserId
摘要：才注释了几个就感觉有点烦烦的了,好象需要耐心的样子.不过吃过午饭好象有可以了.很多地方都没说清楚,希望看的人不要被我误导了,所以要抱着参考的态度看. 1ALTER PROCEDURE dbo.aspnet_Membership_GetUserByUserId --通过用户ID获取用户 2 @UserId UNIQUEIDENTIFIER, 3 ...
阅读全文
aspnet_Membership_GetUserByEmail////aspnet_Membership_GetUserByName
摘要：ALTER PROCEDURE dbo.aspnet_Membership_GetUserByEmail --通过邮箱获取用户名 @ApplicationName NVARCHAR(256), @Email NVARCHAR(256)ASBEGIN IF( @Email IS NULL ) SELECT u.UserName ...
阅读全文
aspnet_Membership_GetPasswordWithFormat////
摘要：1ALTER PROCEDURE dbo.aspnet_Membership_GetPasswordWithFormat 2 @ApplicationName NVARCHAR(256), 3 @UserName NVARCHAR(256) 4AS 5BEGIN 6 DECLARE @Password ...
阅读全文
aspnet_Membership_GetPassword
摘要：ALTER PROCEDURE dbo.aspnet_Membership_GetPassword --获取密码 @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @MaxInvalidPasswordAttempts INT, ...
阅读全文
aspnet_Membership_GetNumberOfUsersOnline
摘要：ALTER PROCEDURE dbo.aspnet_Membership_GetNumberOfUsersOnline --查询在线用户 @ApplicationName NVARCHAR(256), @MinutesSinceLastInActive INT, @TimeZoneAdjustment INT --显示新的本地时间而...
阅读全文
aspnet_Membership_GetAllUsers
摘要：ALTER PROCEDURE dbo.aspnet_Membership_GetAllUsers @ApplicationName NVARCHAR(256), @PageIndex INT, @PageSize INTASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFI...
阅读全文
aspnet_Membership_FindUsersByName
摘要：ALTER PROCEDURE dbo.aspnet_Membership_FindUsersByName @ApplicationName NVARCHAR(256), @UserNameToMatch NVARCHAR(256), @PageIndex INT, @PageSize INTASB...
阅读全文
aspnet_Membership_FindUsersByEmail
摘要：ALTER PROCEDURE dbo.aspnet_Membership_FindUsersByEmail @ApplicationName NVARCHAR(256), @EmailToMatch NVARCHAR(256), @PageIndex INT, @PageSize INTAS...
阅读全文
aspnet_Membership_CreateUser
摘要：ALTER PROCEDURE dbo.aspnet_Membership_CreateUser @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @Password ...
阅读全文
aspnet_Membership_ChangePasswordQuestionAndAnswer
摘要：ALTER PROCEDURE dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @NewPasswordQuestion NVARCHAR(256),/**//*...
阅读全文
aspnet_GetUtcDate
摘要：ALTER PROCEDURE [dbo].aspnet_GetUtcDate @TimeZoneAdjustment INT, /**//*时区的意思*/ @DateNow DATETIME OUTPUT /**//*当前时间(输出参数)*/ASBEGIN SELECT @DateNow = GETUTCDATE() /**//*返回表示当前 UTC ...
阅读全文
aspnet_CheckSchemaVersion
摘要：1ALTER PROCEDURE [dbo].aspnet_CheckSchemaVersion 2 @Feature NVARCHAR(128), 3 @CompatibleSchemaVersion NVARCHAR(128) 4AS 5BEGIN 6 IF (EXISTS( SELECT * 7 F...
阅读全文
aspnet_Applications_CreateApplication
摘要：1ALTER PROCEDURE [dbo].aspnet_Applications_CreateApplication 2 @ApplicationName NVARCHAR(256), 3 @ApplicationId UNIQUEIDENTIFIER OUTPUT 4AS 5BEGIN 6 SELECT @ApplicationId = App...
阅读全文
浙公网安备 33010602011771号