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 · 127 阅读 · 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 · 570 阅读 · 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 · 177 阅读 · 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 · 180 阅读 · 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 · 99 阅读 · 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 · 140 阅读 · 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 · 129 阅读 · 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 · 192 阅读 · 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 · 78 阅读 · 0 评论