07 2010 档案

MSChart应用系列
摘要: collectorId = Convert.ToInt32(Request.QueryString["id"]); Chart1.Series[0].ChartType = SeriesChartType.Spline; Chart1.Series[0].Color = System.Drawing.Color.Blue; Chart1.Series[0].IsValueShownAsLabel ...阅读全文

posted @ 2010-07-28 12:05 badnewfish 阅读(263) | 评论 (1) 编辑

SQLServer2005分页存储过程
摘要: CREATE procedure [dbo].[proc_pagedArticle] --利用SQL 2005中的Row_number() ( @pageIndex int, @pageSize int,@articleType int) as --declare @timediff datetime begin set nocount on; --select @timediff=getdate() select * from (select *,Row_number() over(order by id desc) as IDRank from article where [type] =阅读全文

posted @ 2010-07-15 10:44 badnewfish 阅读(149) | 评论 (2) 编辑

用触发器向动态表名备份数据
摘要: USE [SolarEnergy]GO/****** 对象: Trigger [dbo].[trigger_delete_InstData] 脚本日期: 07/01/2010 15:11:30 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TRIGGER [dbo].[trigger_delete_InstData]on [d...阅读全文

posted @ 2010-07-01 15:16 badnewfish 阅读(72) | 评论 (0) 编辑