随笔分类 - Community Server 2.0 存储过程
对存储过程进行注释说明.因为本人也不太懂,所以本类里的文章主要是个人学习之用.目前对CSS也只是了解一点,数据库中也有很多字段不知道是什么意思.所以仅供参考.
cs_BannedAddresses_Get///cs_BannedNetwork_CreateUpdateDelete///cs_BannedNetworks_Get
摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER Procedure [dbo].[cs_BannedNetwork_CreateUpdateDelete] @BannedNetworkID INT = 0 OUTPUT, ...
阅读全文
cs_BannedAddress_CreateUpdateDelete
摘要：ALTER Procedure [dbo].[cs_BannedAddress_CreateUpdateDelete] @SettingsID INT , @NetworkAddress NVARCHAR(50) , @BannedDate DATETIME , @ActionType INT --活动类型AS ...
阅读全文
cs_ApplicationConfigurationSettings_CreateUpdate///cs_ApplicationConfigurationSettings_Get//cs_Audit_Post
摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_ApplicationConfigurationSettings_CreateUpdate --11, 36, 0, 1, 0( ---------...
阅读全文
aspnet_UsersInRoles_RemoveUsersFromRoles
摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_RemoveUsersFromRoles @ApplicationName NVARCHAR(256), @UserNames NVARCHAR(4000), @RoleNames NVARCHAR(4000)ASBEGIN DECLARE @Applicatio...
阅读全文
aspnet_UsersInRoles_IsUserInRole
摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_IsUserInRole @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @RoleName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUE...
阅读全文
aspnet_UsersInRoles_GetUsersInRoles
摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_GetUsersInRoles --查询某角色的用户 @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT ...
阅读全文
aspnet_UsersInRoles_GetRolesForUser
摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_GetRolesForUser --查询用户的角色 @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT ...
阅读全文
aspnet_UsersInRoles_FindUsersInRole
摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_FindUsersInRole --查询某角色中的所有用户 @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256), @UserNameToMatch NVARCHAR(256)ASBEGIN DECLARE @Ap...
阅读全文
aspnet_UsersInRoles_AddUsersToRoles
摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_AddUsersToRoles --添加用户到角色 @ApplicationName NVARCHAR(256), @UserNames NVARCHAR(4000), @RoleNames NVARCHAR(4000), @T...
阅读全文
aspnet_Users_DeleteUser
摘要：aspnet_Users_DeleteUser ALTER PROCEDURE [dbo].aspnet_Users_DeleteUser --删除用户信息 @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @TablesToDeleteFrom INT, @NumTablesDele...
阅读全文
aspnet_Users_CreateUser
摘要：aspnet_Users_CreateUser ALTER PROCEDURE [dbo].aspnet_Users_CreateUser @ApplicationId UNIQUEIDENTIFIER, @UserName NVARCHAR(256), @IsUserAnonymous BIT,----是否匿名用户 @LastActivityDa...
阅读全文
aspnet_Roles_GetAllRoles///aspnet_Roles_RoleExists
摘要：aspnet_Roles_GetAllRoles ALTER PROCEDURE dbo.aspnet_Roles_GetAllRoles ----获取全部角色( @ApplicationName NVARCHAR(256))ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT @Applicatio...
阅读全文
aspnet_Roles_DeleteRole
摘要：ALTER PROCEDURE dbo.aspnet_Roles_DeleteRole @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256), @DeleteOnlyIfRoleIsEmpty BIT --只有当角色为空时删除(即无用户使用该角色,下面有用...
阅读全文
aspnet_Roles_CreateRole
摘要：ALTER PROCEDURE dbo.aspnet_Roles_CreateRole --创建角色 @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT @ApplicationId ...
阅读全文
aspnet_RegisterSchemaVersion///aspnet_Setup_RestorePermissions////aspnet_UnRegisterSchemaVersion
摘要：aspnet_RegisterSchemaVersion ALTER PROCEDURE [dbo].aspnet_RegisterSchemaVersion --不知道是不是注册版本的意思 @Feature NVARCHAR(128), @CompatibleSchemaVersion NVARCHAR(128), @IsCurrent...
阅读全文
aspnet_Profile_GetProperties////aspnet_Profile_SetProperties
摘要：aspnet_Profile_GetProperties ALTER PROCEDURE dbo.aspnet_Profile_GetProperties @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @TimeZoneAdjustment INTASBEGIN DE...
阅读全文
aspnet_Profile_GetProfiles
摘要：ALTER PROCEDURE dbo.aspnet_Profile_GetProfiles @ApplicationName NVARCHAR(256), @ProfileAuthOptions INT, @PageIndex INT, @PageSize INT, @TimeZoneAd...
阅读全文
aspnet_Profile_GetNumberOfInactiveProfiles
摘要：ALTER PROCEDURE dbo.aspnet_Profile_GetNumberOfInactiveProfiles @ApplicationName NVARCHAR(256), @ProfileAuthOptions INT, @InactiveSinceDate DATETIME,---自从停止活跃开始的时间 @TimeZon...
阅读全文
aspnet_Profile_DeleteProfiles
摘要：ALTER PROCEDURE dbo.aspnet_Profile_DeleteProfiles @ApplicationName NVARCHAR(256), @UserNames NVARCHAR(4000)ASBEGIN DECLARE @UserName NVARCHAR(256) DECLARE @Current...
阅读全文
aspnet_Profile_DeleteInactiveProfiles
摘要：1ALTER PROCEDURE dbo.aspnet_Profile_DeleteInactiveProfiles 2 @ApplicationName NVARCHAR(256), 3 @ProfileAuthOptions INT, 4 @InactiveSinceDate DATETIME, 5 @TimeZoneAdjustme...
阅读全文
浙公网安备 33010602011771号