sql server
关注
分享
扫一扫
vipepai
这个作者很懒，什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
取出5条热点新闻
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[proghot5newsselect] Script Date: 05/12/2010 12:47:03 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =======================...原创 2010-05-20 09:57:57 · 161 阅读 · 0 评论 -
根据新闻id查询新闻内容
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[procselectnewsbyid] Script Date: 05/12/2010 12:45:48 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =====================...2010-05-20 10:03:12 · 631 阅读 · 0 评论 -
根据标题搜索信息
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[procselectnewsbycontent] Script Date: 05/12/2010 12:44:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ================...原创 2010-05-20 10:05:05 · 211 阅读 · 0 评论 -
根据类别id取出该类别下相应的新闻
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[procselectnewsbycaid] Script Date: 05/12/2010 12:19:42 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =====================...原创 2010-05-20 10:06:59 · 222 阅读 · 0 评论 -
分页选取新闻
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[Procselectanynews] Script Date: 05/12/2010 12:18:29 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ========================...原创 2010-05-20 10:16:49 · 139 阅读 · 0 评论 -
修改新闻
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[procnewsupdate] Script Date: 05/12/2010 12:17:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ===========================...原创 2010-05-20 10:17:38 · 188 阅读 · 0 评论 -
增加新闻
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[procnewsinsert] Script Date: 05/12/2010 12:13:23 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ===========================...原创 2010-05-20 10:18:29 · 170 阅读 · 0 评论 -
删除新闻及对其的评论
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[procnewsdelete] Script Date: 05/12/2010 12:12:25 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ===========================...原创 2010-05-20 10:20:11 · 239 阅读 · 0 评论 -
批量删除
USE [Publishing System ]GO/****** Object: StoredProcedure [dbo].[Procdeletesomenews] Script Date: 05/12/2010 10:07:19 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =======================...原创 2010-05-20 10:21:39 · 113 阅读 · 0 评论