简单多用户Blog源码-问答列表|—51aspx.com

综合讨论下载前咨询( 8 人) | 下载后讨论( 0 人 )

joesh***（用户）发表于：2013-06-24 21:24:44

不知道为什么，调试的时候老是出现System.Data.SqlClient.SqlException: 对象名 'View_UpdateBlog' 无效。这个错误，求大神指教啊！

0 个回复
11139***（用户）发表于：2010-12-19 13:10:00

我现在这个模板之后，调试部成功老是出现错误

1 个回复
- diana***（用户）回复于：2010-12-20 09:27:00
  
  一些简单的错误可以通过查找资料来解决的，解决的过程也就是您进步的过程！
haoye***（用户）发表于：2009-02-27 15:36:00

BLOG  ID获取不了

0 个回复
haoye***（用户）发表于：2009-02-27 15:28:00

我注册多个用户，然后测试，发现现在的用户写的日志更新到之前一个用户的日志上了

0 个回复
haoye***（用户）发表于：2009-02-26 16:39:00

<a href="mailto:angel0608@126.com" target="_blank">******</a><a href="mailto:30510671@qq.com" target="_blank">@qq.com</a>  直接发邮箱或者Q我哦，谢谢

1 个回复
- 51asp***（编辑）回复于：2009-02-26 17:52:00
 
 实际如果你装了VS2005就能用Sql2005的，可以看看这个帖子：<a href="http://bbs.51aspx.com/showtopic-5120.html" target="_blank">http://bbs.51aspx.com/showtopic-5120.html</a> 如果实在不行就用下面生成的Sql脚本文件，不过也是Sql2005格式的哦<div class="blockcode"><div id="code_-1"><ol><li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[COMMENT_INFO]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[COMMENT_INFO]( </li> <li> [CommentID] [int] IDENTITY(1,1) NOT NULL, </li> <li> [DiaryID] [int] NOT NULL, </li> <li> [BlogID] [int] NOT NULL, </li> <li> [CommentName] [varchar](50) NOT NULL, </li> <li> [CommentContent] [ntext] NOT NULL, </li> <li> [CommitDate] [datetime] NOT NULL </li> <li>) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_LatestDiary]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_LatestDiary] </li> <li>AS </li> <li>SELECT     TOP (1) dbo.DIARY_INFO.* </li> <li>FROM         dbo.DIARY_INFO </li> <li>ORDER BY ReleaseDate DESC </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_LatestDiary', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "DIARY_INFO" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 121 </li> <li>               Right = 193 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 3 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 9 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1740 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_LatestDiary' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_LatestDiary', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_LatestDiary' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_EditDiary]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li>-- ============================================= </li> <li>-- Description: 修改日志 </li> <li>--              返回修改的日志 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_EditDiary] </li> <li> @DiaryID  int, </li> <li> @Subject  varchar(100), </li> <li> @DiaryContent ntext </li> <li>AS </li> <li>BEGIN TRANSACTION EDITDIARY </li> <li> SET NOCOUNT ON; </li> <li> UPDATE DIARY_INFO </li> <li>    SET Subject = @Subject </li> <li>    ,DiaryContent = @DiaryContent </li> <li>  WHERE DiaryID = @DiaryID </li> <li> -- 返回添加日志 </li> <li> SELECT * FROM DIARY_INFO WHERE DiaryID = @DiaryID </li> <li>COMMIT TRANSACTION EDITDIARY' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DIARY_INFO]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[DIARY_INFO]( </li> <li> [DiaryID] [int] IDENTITY(1,1) NOT NULL, </li> <li> [BlogID] [int] NOT NULL, </li> <li> [Subject] [varchar](100) NULL, </li> <li> [DiaryContent] [ntext] NULL, </li> <li> [ReleaseDate] [datetime] NULL, </li> <li> [LastCommentDate] [datetime] NULL, </li> <li> [CountComment] [int] NOT NULL CONSTRAINT [DF_DIARY_INFO_CountComment]  DEFAULT ((0)) </li> <li>) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PHOTO_INFO]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[PHOTO_INFO]( </li> <li> [PhotoID] [int] IDENTITY(1,1) NOT NULL, </li> <li> [BlogID] [int] NOT NULL, </li> <li> [Subject] [varchar](50) NOT NULL, </li> <li> [Url] [varchar](500) NOT NULL, </li> <li> [UpLoadDate] [datetime] NOT NULL </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[USER_INFO]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[USER_INFO]( </li> <li> [UserID] [int] IDENTITY(1,1) NOT NULL, </li> <li> [LoginName] [varchar](50) NOT NULL, </li> <li> [DisplayName] [varchar](50) NOT NULL, </li> <li> [BlogName] [varchar](50) NULL, </li> <li> [Password] [varchar](50) NOT NULL, </li> <li> [Email] [varchar](100) NULL, </li> <li> [RegionDate] [datetime] NULL CONSTRAINT [DF_USER_INFO_RegionDate]  DEFAULT (getdate()), </li> <li> [LastUpdateDate] [datetime] NULL CONSTRAINT [DF_USER_INFO_LastUpdateDate]  DEFAULT (getdate()), </li> <li> [Enable] [bit] NOT NULL CONSTRAINT [DF_USER_INFO_enable]  DEFAULT ((1)), </li> <li> CONSTRAINT [PK_USER_INFO] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [UserID] ASC </li> <li>)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_AddComment]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li> </li> <li>-- ============================================= </li> <li>-- Description: 添加日志 </li> <li>--              更新日志最后评论日期 </li> <li>--              更新日志评论数 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_AddComment] </li> <li> @DiaryID  int, </li> <li> @CommentName varchar(50), </li> <li> @CommentContent ntext </li> <li>AS </li> <li>BEGIN TRANSACTION ADDCOMMENT </li> <li> SET NOCOUNT ON; </li> <li> -- 获取现在时间 </li> <li> DECLARE @CommitDate AS datetime </li> <li> SET @CommitDate = GETDATE() </li> <li> -- 获取博客ID </li> <li> DECLARE @BlogID AS int </li> <li> SELECT @BlogID = BlogID </li> <li>   FROM DIARY_INFO </li> <li>  WHERE DiaryID = @DiaryID </li> <li> -- 更日志信息 </li> <li> UPDATE DIARY_INFO </li> <li>    SET LastCommentDate = @CommitDate </li> <li>       ,CountComment = CountComment + 1 </li> <li>  WHERE DiaryID = @DiaryID </li> <li> -- 添加评论 </li> <li> INSERT INTO COMMENT_INFO </li> <li>      (DiaryID </li> <li>      ,BlogID </li> <li>      ,CommentName </li> <li>      ,CommentContent </li> <li>      ,CommitDate) </li> <li>   VALUES </li> <li>      (@DiaryID </li> <li>      ,@BlogID </li> <li>      ,@CommentName </li> <li>      ,@CommentContent </li> <li>      ,@CommitDate) </li> <li> -- 返回评论 </li> <li> SELECT * FROM COMMENT_INFO WHERE DiaryID = @DiaryID ORDER BY CommitDate DESC </li> <li>COMMIT TRANSACTION ADDCOMMENT </li> <li> </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_DeleteDiary]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li> </li> <li>-- ============================================= </li> <li>-- Description: 删除日志 </li> <li>--              返回最新的日志 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_DeleteDiary] </li> <li> @DiaryID  int </li> <li>AS </li> <li>BEGIN TRANSACTION DELETEDIARY </li> <li> SET NOCOUNT ON; </li> <li> DELETE FROM DIARY_INFO </li> <li>    WHERE DiaryID = @DiaryID </li> <li> DELETE FROM COMMENT_INFO </li> <li>    WHERE DiaryID = @DiaryID </li> <li> -- 返回最新日志 </li> <li> SELECT * FROM View_LatestDiary </li> <li>COMMIT TRANSACTION DELETEDIARY </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_PreviousDiary]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li>-- ============================================= </li> <li>-- Description: 获取指定博客指定日志上一篇日志 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_PreviousDiary] </li> <li> @DiaryID  int, </li> <li> @BlogID   int </li> <li>AS </li> <li>BEGIN </li> <li> SET NOCOUNT ON; </li> <li> DECLARE @PreviousDiaryID AS int </li> <li> SELECT @PreviousDiaryID = MAX(DiaryID) </li> <li>   FROM DIARY_INFO </li> <li>  WHERE DiaryID < @DiaryID </li> <li>    AND BlogID = @BlogID </li> <li> IF (@PreviousDiaryID IS null) </li> <li>  SET @PreviousDiaryID = @DiaryID </li> <li> -- 返回上一篇日志 </li> <li> SELECT * FROM DIARY_INFO WHERE DiaryID = @PreviousDiaryID </li> <li>END </li> <li> </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_NextDiary]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li>-- ============================================= </li> <li>-- Description: 获取指定博客指定日志下一篇日志 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_NextDiary] </li> <li> @DiaryID  int, </li> <li> @BlogID   int </li> <li>AS </li> <li>BEGIN </li> <li> SET NOCOUNT ON; </li> <li> DECLARE @NextDiaryID AS int </li> <li> SELECT @NextDiaryID = MIN(DiaryID) </li> <li>   FROM DIARY_INFO </li> <li>  WHERE DiaryID > @DiaryID </li> <li>    AND BlogID = @BlogID </li> <li> IF (@NextDiaryID IS null) </li> <li>  SET @NextDiaryID = @DiaryID </li> <li> -- 返回下一篇日志 </li> <li> SELECT * FROM DIARY_INFO WHERE DiaryID = @NextDiaryID </li> <li>END </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_NewDiary]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_NewDiary] </li> <li>AS </li> <li>SELECT     TOP (10) DiaryID, Subject </li> <li>FROM         dbo.DIARY_INFO </li> <li>ORDER BY ReleaseDate DESC </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_NewDiary', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "DIARY_INFO" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 121 </li> <li>               Right = 207 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 3 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_NewDiary' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_NewDiary', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_NewDiary' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_CommentDiary]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_CommentDiary] </li> <li>AS </li> <li>SELECT     TOP (10) DiaryID, Subject </li> <li>FROM         dbo.DIARY_INFO </li> <li>WHERE     (CountComment > 0) </li> <li>ORDER BY LastCommentDate DESC </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_CommentDiary', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "DIARY_INFO" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 121 </li> <li>               Right = 207 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 3 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 9 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_CommentDiary' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_CommentDiary', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_CommentDiary' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_AddPhoto]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li>-- ============================================= </li> <li>-- Description: 添加照片 </li> <li>--              返回添加照片 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_AddPhoto] </li> <li> @BlogID   int, </li> <li> @Subject  varchar(50), </li> <li> @Url   varchar(500) </li> <li>AS </li> <li>BEGIN TRANSACTION ADDPHOTO </li> <li> SET NOCOUNT ON; </li> <li> -- 获取现在时间 </li> <li> DECLARE @UploadDate AS datetime </li> <li> SET @UploadDate = GETDATE() </li> <li> -- 添加照片 </li> <li> INSERT INTO PHOTO_INFO </li> <li>      (BlogID </li> <li>      ,Subject </li> <li>      ,Url </li> <li>      ,UploadDate) </li> <li>   VALUES </li> <li>      (@BlogID </li> <li>      ,@Subject </li> <li>      ,@Url </li> <li>      ,@UploadDate) </li> <li> -- 返回添加照片 </li> <li> SELECT * FROM PHOTO_INFO WHERE PhotoID = @@IDENTITY </li> <li>COMMIT TRANSACTION ADDPHOTO </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_DeletePhoto]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li> </li> <li>-- ============================================= </li> <li>-- Description: 删除照片 </li> <li>--              返回最新的照片 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_DeletePhoto] </li> <li> @PhotoID  int </li> <li>AS </li> <li>BEGIN TRANSACTION DELETEDIARY </li> <li> SET NOCOUNT ON; </li> <li> DELETE FROM PHOTO_INFO </li> <li>    WHERE PhotoID = @PhotoID </li> <li> -- 返回最新日志 </li> <li> SELECT TOP 1 * FROM PHOTO_INFO </li> <li>    ORDER BY UploadDate DESC </li> <li>COMMIT TRANSACTION DELETEDIARY </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_NextPhoto]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li>-- ============================================= </li> <li>-- Description: 获取指定博客指定照片下一张照片 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_NextPhoto] </li> <li> @PhotoID  int, </li> <li> @BlogID   int </li> <li>AS </li> <li>BEGIN </li> <li> SET NOCOUNT ON; </li> <li> DECLARE @NextPhotoID AS int </li> <li> SELECT @NextPhotoID = MIN(PhotoID) </li> <li>   FROM Photo_INFO </li> <li>  WHERE PhotoID > @PhotoID </li> <li>    AND BlogID = @BlogID </li> <li> IF (@NextPhotoID IS null) </li> <li>  SET @NextPhotoID = @PhotoID </li> <li> -- 返回下一张照片 </li> <li> SELECT * FROM Photo_INFO WHERE PhotoID = @NextPhotoID </li> <li>END </li> <li> </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_PreviousPhoto]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li> </li> <li>-- ============================================= </li> <li>-- Description: 获取指定博客指定照片上一张照片 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_PreviousPhoto] </li> <li> @PhotoID  int, </li> <li> @BlogID   int </li> <li>AS </li> <li>BEGIN </li> <li> SET NOCOUNT ON; </li> <li> DECLARE @PreviousPhotoID AS int </li> <li> SELECT @PreviousPhotoID = MAX(PhotoID) </li> <li>   FROM Photo_INFO </li> <li>  WHERE PhotoID < @PhotoID </li> <li>    AND BlogID = @BlogID </li> <li> IF (@PreviousPhotoID IS null) </li> <li>  SET @PreviousPhotoID = @PhotoID </li> <li> -- 返回上一张照片 </li> <li> SELECT * FROM Photo_INFO WHERE PhotoID = @PreviousPhotoID </li> <li>END </li> <li> </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Proc_AddDiary]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N' </li> <li>-- ============================================= </li> <li>-- Description: 添加日志 </li> <li>--              更新博客最后跟新日期 </li> <li>--              返回添加日志 </li> <li>-- ============================================= </li> <li>CREATE PROCEDURE [dbo].[Proc_AddDiary] </li> <li> @BlogID   int, </li> <li> @Subject  varchar(100), </li> <li> @DiaryContent ntext </li> <li>AS </li> <li>BEGIN TRANSACTION ADDDIARY </li> <li> SET NOCOUNT ON; </li> <li> -- 获取现在时间 </li> <li> DECLARE @ReleaseDate AS datetime </li> <li> SET @ReleaseDate = GETDATE() </li> <li> -- 更新博客信息 </li> <li> UPDATE USER_INFO </li> <li>    SET LastUpdateDate = @ReleaseDate </li> <li>  WHERE UserID = @BlogID </li> <li> -- 添加日志 </li> <li> INSERT INTO DIARY_INFO </li> <li>      (BlogID </li> <li>      ,Subject </li> <li>      ,DiaryContent </li> <li>      ,ReleaseDate) </li> <li>   VALUES </li> <li>      (@BlogID </li> <li>      ,@Subject </li> <li>      ,@DiaryContent </li> <li>      ,@ReleaseDate) </li> <li> -- 返回添加日志 </li> <li> SELECT * FROM DIARY_INFO WHERE DiaryID = @@IDENTITY </li> <li>COMMIT TRANSACTION ADDDIARY' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_RegionBlog]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_RegionBlog] </li> <li>AS </li> <li>SELECT     TOP (10) UserID, BlogName </li> <li>FROM         dbo.USER_INFO </li> <li>ORDER BY RegionDate DESC </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_RegionBlog', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "USER_INFO" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 121 </li> <li>               Right = 197 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 4 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 9 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_RegionBlog' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_RegionBlog', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_RegionBlog' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[View_UpdateBlog]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[View_UpdateBlog] </li> <li>AS </li> <li>SELECT     TOP (10) UserID, BlogName </li> <li>FROM         dbo.USER_INFO </li> <li>ORDER BY LastUpdateDate DESC </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'View_UpdateBlog', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "USER_INFO" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 121 </li> <li>               Right = 197 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 4 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 9 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_UpdateBlog' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'View_UpdateBlog', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'View_UpdateBlog' </li> </ol></div>复制代码</div>
haoye***（用户）发表于：2009-02-26 15:45:00

好象用SQL2000读不了那个数据库:'(

0 个回复
yaoya***（作者）发表于：2009-02-16 10:33:00

我做个附件上传，希望有人能帮帮我。再此多谢了！

1 个回复
- 51asp***（编辑）回复于：2009-02-16 12:13:00
 
 你所提的问题已经解决，<a href="http://www.51aspx.com/CV/SimpleUsersBlog/" target="_blank">http://www.51aspx.com/CV/SimpleUsersBlog/</a>

源码信息

简单多用户Blog源码

最新源码评论

综合讨论下载前咨询( 8 人) | 下载后讨论( 0 人 )

源码信息

简单多用户Blog源码

最新源码评论

综合讨论 下载前咨询( 8 人) | 下载后讨论( 0 人 )

温馨提示

综合讨论下载前咨询( 8 人) | 下载后讨论( 0 人 )