MainIsUsed - 博客园

2006年9月20日

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_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 阅读(305) 评论(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 阅读(149) 评论(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 阅读(286) 评论(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) 编辑

2006年9月8日

在一表中设置组合主键（两个字段组合成一个主键）

摘要：首先一个表是不能有两个主键的。但是可以有两个字段组合成一个主键，这就是为什么有时候表里为什么会有两个字段都有主键的标志，那是因为他们组合成了一个主键了。我们可以先删除了原来的主键再用TSQL建 alter table tablename add constraint pk_name primary key ... 阅读全文

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

2006年9月7日

又来牢骚一下

摘要：是对与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 阅读(160) 评论(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 阅读(141) 评论(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 阅读(199) 评论(0) 推荐(0) 编辑

2006年9月6日

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 阅读(214) 评论(0) 推荐(0) 编辑