2006 年 9月随笔档案 - MainIsUsed

ORACLE 的SQL语句与SQL SERVER 中的SQL语句中一些不同的地方

摘要：因为公司的数据库是用ORACLE的,所以现在操作数据也就转向ORACLE方向了.我负责是网站部分的数据处理,所以头就叫我用OLEDB连数据,这些也就是改改引用就可以了,郁闷的是有些SQL操作在ORACLE中是和原来的SQL SERVER 中的是不同的.有时候就知道为什么错误,一直在那里找,后面才明白原来在SQL SERVER 中正确的语法在ORACLE中就未必正确了,于是就要找GOOGL... 阅读全文

posted @ 2006-09-29 15:38 MainIsUsed 阅读(299) 评论(0) 推荐(0) 编辑

cs_Moderate_Forum_Roles///cs_Moderate_Forums///cs_Moderate_Post_Move(最后的注释)

摘要：cs_Moderate_Post_Move(最后的注释)Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_Moderate_Post_Move/**//*因为某些原因,我的伙伴要离开.低落啊!注释... 阅读全文

posted @ 2006-09-20 16:30 MainIsUsed 阅读(265) 评论(0) 推荐(0) 编辑

cs_Moderate_ApprovePost///cs_Moderate_CheckUser///cs_Moderate_DeletePost

摘要：cs_Moderate_DeletePostCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_Moderate_DeletePost( @PostID INT, @DeletedBy INT... 阅读全文

posted @ 2006-09-20 16:26 MainIsUsed 阅读(267) 评论(0) 推荐(0) 编辑

cs_Links_Get///cs_MarkPostAsRead///cs_Message_CreateUpdateDelete

摘要：cs_Message_CreateUpdateDeleteCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure [dbo].cs_Message_CreateUpdateDelete( @MessageID int, ... 阅读全文

posted @ 2006-09-20 16:22 MainIsUsed 阅读(180) 评论(0) 推荐(0) 编辑

cs_LinkCategories_Get///cs_LinkCategory_CreateUpdateDelete//cs_LinkCategory_UpdateSortOrder

摘要：cs_LinkCategory_UpdateSortOrderCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure [dbo].cs_LinkCategory_UpdateSortOrder( @Li... 阅读全文

posted @ 2006-09-20 16:17 MainIsUsed 阅读(264) 评论(0) 推荐(0) 编辑

cs_Link_CreateUpdateDelete///cs_Link_UpdateSortOrder

摘要：cs_Link_UpdateSortOrderCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure [dbo].cs_Link_UpdateSortOrder( @LinkID int, ... 阅读全文

posted @ 2006-09-20 16:13 MainIsUsed 阅读(248) 评论(0) 推荐(0) 编辑

[cs_InkData_Get]//[cs_InkData_Update]///cs_Licenses_Get///cs_Licenses_Update

摘要：cs_Licenses_UpdateCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE dbo.cs_Licenses_Update @LicenseID uniqueidentifier, @LicenseT... 阅读全文

posted @ 2006-09-20 16:11 MainIsUsed 阅读(211) 评论(0) 推荐(0) 编辑

cs_Image_CreateUpdateDelete//cs_InkData_Add//cs_InkData_Delete

摘要：cs_InkData_DeleteCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER Proc [dbo].[cs_InkData_Delete]( @InkID int, @SectionID int, @Settings... 阅读全文

posted @ 2006-09-20 16:08 MainIsUsed 阅读(199) 评论(0) 推荐(0) 编辑

cs_guestbook_Post_Delete

摘要：cs_guestbook_Post_DeleteCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_guestbook_Post_Delete( @SectionID int, @Post... 阅读全文

posted @ 2006-09-20 16:07 MainIsUsed 阅读(148) 评论(0) 推荐(0) 编辑

cs_guestbook_GetPosts///cs_guestbook_Post_Create

摘要：ALTER PROCEDURE [dbo].cs_guestbook_Post_Create( @SectionID int, @Subject nvarchar(256), @UserID int, @PostAuthor nvarchar(64) = null, @Body ntext, @FormattedBody ntext, @Emotic... 阅读全文

posted @ 2006-09-20 16:05 MainIsUsed 阅读(417) 评论(0) 推荐(0) 编辑

cs_Groups_Get///cs_Groups_ReOrder ///cs_Groups_ResetOrder

摘要：cs_Groups_ResetOrderCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER Proc [dbo].cs_Groups_ResetOrder( @ApplicationType int, @SettingsID in... 阅读全文

posted @ 2006-09-20 16:03 MainIsUsed 阅读(253) 评论(0) 推荐(0) 编辑

cs_GetUserIDByAppToken///cs_Group_CreateUpdateDelete

摘要：cs_Group_CreateUpdateDeleteCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_Group_CreateUpdateDelete( @GroupID in... 阅读全文

posted @ 2006-09-20 15:59 MainIsUsed 阅读(198) 评论(0) 推荐(0) 编辑

cs_gallery_Search_PostReindex///cs_GetAnonymousUserID///cs_GetSectionSubscriptionType///cs_GetSectionSubscriptionTypes//cs_GetTotalPostCount

摘要：cs_GetTotalPostCountCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_GetTotalPostCount( @SettingsID int) ASSET Transacti... 阅读全文

posted @ 2006-09-20 15:57 MainIsUsed 阅读(196) 评论(0) 推荐(0) 编辑

cs_forums_threads_ThreadsRead///cs_fourm_Feedback_Get

摘要：ALTER PROCEDURE [dbo].[cs_fourm_Feedback_Get]( @SectionID int ,@ParentID int = null ,@PostType int = 12 -- 1 and 3 are image and comment types for gallery ,@Approved int = null /**//... 阅读全文

posted @ 2006-09-20 15:54 MainIsUsed 阅读(166) 评论(0) 推荐(0) 编辑

cs_forums_Posts_PostSet_RSSThreadless//cs_forums_Thread_Get

摘要：cs_forums_Thread_GetCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_forums_Thread_Get/**//* Procedure for getting basic i... 阅读全文

posted @ 2006-09-20 15:53 MainIsUsed 阅读(194) 评论(0) 推荐(0) 编辑

cs_forums_Posts_PostSet

摘要：ALTER PROCEDURE dbo.cs_forums_Posts_PostSet( @PostID int, @PageIndex int, @PageSize int, @SortBy int, @SortOrder bit, @UserID int, @ReturnRecordCount bit, @AllowUnapproved ... 阅读全文

posted @ 2006-09-20 15:52 MainIsUsed 阅读(347) 评论(0) 推荐(0) 编辑

cs_forums_Post

摘要：cs_forums_PostCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE dbo.cs_forums_Post( @PostID int, @UserID int, @TrackViews bit,... 阅读全文

posted @ 2006-09-20 15:51 MainIsUsed 阅读(178) 评论(0) 推荐(0) 编辑

cs_forums_GetForumsModeratedByUser///cs_forums_GetUnmoderatedPostStatus

摘要：cs_forums_GetUnmoderatedPostStatusCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_forums_GetUnmoderatedPostStatus( @Section... 阅读全文

posted @ 2006-09-20 15:49 MainIsUsed 阅读(175) 评论(0) 推荐(0) 编辑

cs_forums_Moderate_PostSet

摘要：cs_forums_Moderate_PostSetCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE dbo.cs_forums_Moderate_PostSet( @SectionID int, ... 阅读全文

posted @ 2006-09-20 15:49 MainIsUsed 阅读(207) 评论(0) 推荐(0) 编辑

cs_Folder_RenameFolder///cs_forums_GetForumMessages///cs_forums_GetForumModerators

摘要：cs_forums_GetForumModeratorsCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_forums_GetForumModerators( @SectionID i... 阅读全文

posted @ 2006-09-20 11:44 MainIsUsed 阅读(306) 评论(0) 推荐(0) 编辑

cs_Folder_GetFolders///cs_Folder_GetSummary///cs_Folder_MoveFolder

摘要：cs_Folder_MoveFolderCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROC [dbo].cs_Folder_MoveFolder @FolderId INT, @NewParentFolderId INT... 阅读全文

posted @ 2006-09-20 11:42 MainIsUsed 阅读(213) 评论(0) 推荐(0) 编辑

cs_Folder_AddFolder///cs_Folder_DeleteFolder///cs_Folder_GetFeeds

摘要：cs_Folder_GetFeedsCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROC [dbo].cs_Folder_GetFeeds @UserId INT, @SettingsID int, @FolderI... 阅读全文

posted @ 2006-09-20 11:41 MainIsUsed 阅读(150) 评论(0) 推荐(0) 编辑

cs_Feed_UpdateFeedStatus///cs_FeedPost_GetPost///cs_FeedPost_GetPostFullDetails///cs_FeedPost_UpdatePosts

摘要：cs_FeedPost_UpdatePostsCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROC [dbo].cs_FeedPost_UpdatePosts @FeedId INT, @FeedItemList NTEX... 阅读全文

posted @ 2006-09-20 11:37 MainIsUsed 阅读(241) 评论(0) 推荐(0) 编辑

cs_Feed_GetProperties///cs_Feed_GetUsers///cs_Feed_MoveFeed///cs_Feed_Update

摘要：cs_Feed_UpdateCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROC [dbo].cs_Feed_Update @FeedId INT, @Url NVARCHAR(255), @Title NVARCH... 阅读全文

posted @ 2006-09-20 11:34 MainIsUsed 阅读(290) 评论(0) 推荐(0) 编辑

cs_Feed_GetAll_ModifiedSince///cs_Feed_GetFeed///cs_Feed_GetFeedPosts

摘要：cs_Feed_GetFeedPostsCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROC [dbo].cs_Feed_GetFeedPosts --引用帖子 @FeedId INT, @UserId INT, ... 阅读全文

posted @ 2006-09-20 11:30 MainIsUsed 阅读(199) 评论(0) 推荐(0) 编辑

又来牢骚一下

摘要：是对与Community Server 2.0中的存储过程的一点看法的.看到目前也差不多清楚了他的基本写法了. 就是习惯用事务来处理,其中有很多判断.判断包括很多,比如通常本应在属性里判断的,他好象都判断掉了.然后在调用这些存储过程的时候就直接传参数就可以了,而不用判断之后再传. 但是应该也有判断的,因为没看全,也有很多没看懂,所以就只能这样说了.=.= ... 阅读全文

posted @ 2006-09-07 13:22 MainIsUsed 阅读(141) 评论(1) 推荐(0) 编辑

cs_Feed_AddFeed///cs_Feed_GetAll

摘要：cs_Feed_GetAllCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROC [dbo].cs_Feed_GetAll( @SettingsID int)AS/**//*查询全部引用,好象越来越像是引用的意思了.*/SELE... 阅读全文

posted @ 2006-09-07 13:10 MainIsUsed 阅读(161) 评论(0) 推荐(0) 编辑

cs_Favorites_GetUsers///cs_Favorites_GetUsersWatching

摘要：cs_Favorites_GetUsersWatchingCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure dbo.cs_Favorites_GetUsersWatching( @UserID int... 阅读全文

posted @ 2006-09-07 13:09 MainIsUsed 阅读(143) 评论(0) 推荐(0) 编辑

cs_Favorites_GetUsers///cs_Favorites_GetUsersWatching

摘要：cs_Favorites_GetUsersWatchingCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure dbo.cs_Favorites_GetUsersWatching( @UserID int... 阅读全文

posted @ 2006-09-07 13:08 MainIsUsed 阅读(149) 评论(0) 推荐(0) 编辑

cs_Favorites_Get///cs_Favorites_GetSections

摘要：cs_Favorites_GetSectionsCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure dbo.cs_Favorites_GetSections( @UserID int, @Sett... 阅读全文

posted @ 2006-09-07 13:07 MainIsUsed 阅读(200) 评论(0) 推荐(0) 编辑

cs_Favorite_GetByUserItem

摘要：cs_Favorite_GetByUserItemCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> 1ALTER procedure dbo.cs_Favorite_GetByUserItem 2( 3 @SettingsID i... 阅读全文

posted @ 2006-09-06 09:17 MainIsUsed 阅读(231) 评论(0) 推荐(0) 编辑

cs_Favorite_Delete///cs_Favorite_Get

摘要：cs_Favorite_GetCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure dbo.cs_Favorite_Get( @FavoriteType int, @FavoriteID ... 阅读全文

posted @ 2006-09-06 09:16 MainIsUsed 阅读(215) 评论(0) 推荐(0) 编辑

cs_Exceptions_Log///cs_Favorite_Add

摘要：cs_Favorite_AddCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE dbo.cs_Favorite_Add( @SettingsID int, @UserID ... 阅读全文

posted @ 2006-09-06 09:14 MainIsUsed 阅读(338) 评论(0) 推荐(0) 编辑

cs_Exceptions_Get

摘要：cs_Exceptions_GetCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER procedure [dbo].cs_Exceptions_Get( @SettingsID int, @ExceptionType int ... 阅读全文

posted @ 2006-09-06 09:09 MainIsUsed 阅读(181) 评论(0) 推荐(0) 编辑

cs_EventLog_Add///cs_EventLog_Clear////cs_EventLog_GetEntries///cs_EventLog_GetEntry

摘要：cs_EventLog_GetEntryCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_EventLog_GetEntry( @EntryID int)AS SELECT E... 阅读全文

posted @ 2006-09-06 09:08 MainIsUsed 阅读(194) 评论(0) 推荐(0) 编辑

cs_es_Search_Queue_Get///cs_es_Search_QueueManager

摘要：cs_es_Search_QueueManagerCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER Proc [dbo].cs_es_Search_QueueManager( @PostID int, @SettingsID i... 阅读全文

posted @ 2006-09-06 09:05 MainIsUsed 阅读(216) 评论(0) 推荐(0) 编辑

cs_Emails_TrackingSection////cs_Emails_TrackingThread

摘要：cs_Emails_TrackingSectionCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_Emails_TrackingSection( @PostID INT, @Sett... 阅读全文

posted @ 2006-09-05 09:14 MainIsUsed 阅读(170) 评论(0) 推荐(0) 编辑

cs_EmailQueue_Failure///cs_Emails_Dequeue///cs_Emails_Enqueue

摘要：cs_EmailQueue_FailureCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER proc dbo.cs_EmailQueue_Failure @EmailID uniqueidentifier, @FailureIn... 阅读全文

posted @ 2006-09-05 09:11 MainIsUsed 阅读(218) 评论(0) 推荐(0) 编辑

cs_Content_UpdateDate///cs_DisallowedName_CreateUpdateDelete///cs_DisallowedNames_Get

摘要：cs_Content_UpdateDateCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].[cs_Content_UpdateDate]( @ContentID int)AS UPDATE ... 阅读全文

posted @ 2006-09-05 09:02 MainIsUsed 阅读(205) 评论(0) 推荐(0) 编辑

cs_Content_CreateUpdateDelete///cs_Content_GetList///cs_Content_Load

摘要：cs_Content_GetListCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].[cs_Content_GetList]( @SettingsID int)AS SELECT ... 阅读全文

posted @ 2006-09-05 09:00 MainIsUsed 阅读(151) 评论(0) 推荐(0) 编辑

cs_Censorship_CreateUpdateDelete///cs_Censorships_Get

摘要：cs_Censorship_CreateUpdateDelete --审核制度创建更新删除Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER proc [dbo].cs_Censorship_CreateUpdateDelete --审核制度... 阅读全文

posted @ 2006-09-05 08:58 MainIsUsed 阅读(233) 评论(0) 推荐(0) 编辑

cs_BlogActivityNightlyJob//cs_BlogActivityReportAggregate_Get///cs_BlogActivityReportRecords_Get

摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->ALTER PROCEDURE [dbo].cs_BlogActivityNightlyJobASSET Transaction Isolation Level Read UNCOMMITTEDB... 阅读全文

posted @ 2006-09-04 11:22 MainIsUsed 阅读(243) 评论(0) 推荐(0) 编辑

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, ... 阅读全文

posted @ 2006-09-04 11:18 MainIsUsed 阅读(234) 评论(0) 推荐(0) 编辑

cs_BannedAddress_CreateUpdateDelete

摘要：ALTER Procedure [dbo].[cs_BannedAddress_CreateUpdateDelete] @SettingsID INT , @NetworkAddress NVARCHAR(50) , @BannedDate DATETIME , @ActionType INT --活动类型AS ... 阅读全文

posted @ 2006-09-04 11:16 MainIsUsed 阅读(224) 评论(0) 推荐(0) 编辑

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( ---------... 阅读全文

posted @ 2006-09-04 11:12 MainIsUsed 阅读(176) 评论(0) 推荐(0) 编辑

aspnet_UsersInRoles_RemoveUsersFromRoles

摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_RemoveUsersFromRoles @ApplicationName NVARCHAR(256), @UserNames NVARCHAR(4000), @RoleNames NVARCHAR(4000)ASBEGIN DECLARE @Applicatio... 阅读全文

posted @ 2006-09-04 10:58 MainIsUsed 阅读(367) 评论(0) 推荐(0) 编辑

aspnet_UsersInRoles_IsUserInRole

摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_IsUserInRole @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @RoleName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUE... 阅读全文

posted @ 2006-09-04 10:56 MainIsUsed 阅读(364) 评论(0) 推荐(0) 编辑

aspnet_UsersInRoles_GetUsersInRoles

摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_GetUsersInRoles --查询某角色的用户 @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT ... 阅读全文

posted @ 2006-09-01 16:58 MainIsUsed 阅读(218) 评论(0) 推荐(0) 编辑

aspnet_UsersInRoles_GetRolesForUser

摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_GetRolesForUser --查询用户的角色 @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT ... 阅读全文

posted @ 2006-09-01 16:57 MainIsUsed 阅读(420) 评论(0) 推荐(0) 编辑

aspnet_UsersInRoles_FindUsersInRole

摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_FindUsersInRole --查询某角色中的所有用户 @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256), @UserNameToMatch NVARCHAR(256)ASBEGIN DECLARE @Ap... 阅读全文

posted @ 2006-09-01 16:56 MainIsUsed 阅读(385) 评论(0) 推荐(0) 编辑

aspnet_UsersInRoles_AddUsersToRoles

摘要：ALTER PROCEDURE dbo.aspnet_UsersInRoles_AddUsersToRoles --添加用户到角色 @ApplicationName NVARCHAR(256), @UserNames NVARCHAR(4000), @RoleNames NVARCHAR(4000), @T... 阅读全文

posted @ 2006-09-01 16:55 MainIsUsed 阅读(742) 评论(0) 推荐(0) 编辑

面币思过

摘要：才几天下来就有点坚持不住了,确实是件需要耐心的事情啊. 越注释到后面注释越简单了,自己都感觉写了是等于没写.好象是在被人逼着做一样.失败. 可能是因为存储过程的写法好象都没什么变化,一直看着同一种写法,然后就有点腻了.不管怎样先鼓励一下自己,一定要坚持下来.不知道有没这必要呢. 阅读全文

posted @ 2006-09-01 13:52 MainIsUsed 阅读(239) 评论(0) 推荐(0) 编辑

aspnet_Users_DeleteUser

摘要：aspnet_Users_DeleteUser ALTER PROCEDURE [dbo].aspnet_Users_DeleteUser --删除用户信息 @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @TablesToDeleteFrom INT, @NumTablesDele... 阅读全文

posted @ 2006-09-01 09:05 MainIsUsed 阅读(579) 评论(0) 推荐(0) 编辑

aspnet_Users_CreateUser

摘要：aspnet_Users_CreateUser ALTER PROCEDURE [dbo].aspnet_Users_CreateUser @ApplicationId UNIQUEIDENTIFIER, @UserName NVARCHAR(256), @IsUserAnonymous BIT,----是否匿名用户 @LastActivityDa... 阅读全文

posted @ 2006-09-01 09:04 MainIsUsed 阅读(437) 评论(0) 推荐(0) 编辑

aspnet_Roles_GetAllRoles///aspnet_Roles_RoleExists

摘要：aspnet_Roles_GetAllRoles ALTER PROCEDURE dbo.aspnet_Roles_GetAllRoles ----获取全部角色( @ApplicationName NVARCHAR(256))ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT @Applicatio... 阅读全文

posted @ 2006-09-01 09:04 MainIsUsed 阅读(440) 评论(0) 推荐(0) 编辑

aspnet_Roles_DeleteRole

摘要：ALTER PROCEDURE dbo.aspnet_Roles_DeleteRole @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256), @DeleteOnlyIfRoleIsEmpty BIT --只有当角色为空时删除(即无用户使用该角色,下面有用... 阅读全文

posted @ 2006-09-01 09:02 MainIsUsed 阅读(407) 评论(0) 推荐(0) 编辑

aspnet_Roles_CreateRole

摘要：ALTER PROCEDURE dbo.aspnet_Roles_CreateRole --创建角色 @ApplicationName NVARCHAR(256), @RoleName NVARCHAR(256)ASBEGIN DECLARE @ApplicationId UNIQUEIDENTIFIER SELECT @ApplicationId ... 阅读全文

posted @ 2006-09-01 09:01 MainIsUsed 阅读(464) 评论(0) 推荐(0) 编辑

aspnet_RegisterSchemaVersion///aspnet_Setup_RestorePermissions////aspnet_UnRegisterSchemaVersion

摘要：aspnet_RegisterSchemaVersion ALTER PROCEDURE [dbo].aspnet_RegisterSchemaVersion --不知道是不是注册版本的意思 @Feature NVARCHAR(128), @CompatibleSchemaVersion NVARCHAR(128), @IsCurrent... 阅读全文

posted @ 2006-09-01 09:00 MainIsUsed 阅读(308) 评论(0) 推荐(0) 编辑

aspnet_Profile_GetProperties////aspnet_Profile_SetProperties

摘要：aspnet_Profile_GetProperties ALTER PROCEDURE dbo.aspnet_Profile_GetProperties @ApplicationName NVARCHAR(256), @UserName NVARCHAR(256), @TimeZoneAdjustment INTASBEGIN DE... 阅读全文

posted @ 2006-09-01 08:57 MainIsUsed 阅读(686) 评论(0) 推荐(0) 编辑

aspnet_Profile_GetProfiles

摘要：ALTER PROCEDURE dbo.aspnet_Profile_GetProfiles @ApplicationName NVARCHAR(256), @ProfileAuthOptions INT, @PageIndex INT, @PageSize INT, @TimeZoneAd... 阅读全文

posted @ 2006-09-01 08:54 MainIsUsed 阅读(439) 评论(0) 推荐(0) 编辑