摘要:
1 合理的索引设计: 例:表record有620000行,试看在不同的索引下,下面几个SQL的运行情况: 语句A SELECT count(*) FROM record WHERE datebetween'19991201' and'19991214‘ and amount 2000 语句B SELECT count(*) FROM record WHERE date '19990901' and place IN ('BJ','SH') 语句C SELECT date,sum(amount) FROM record group by date 1 在date上建有一个非聚集索引 A:(2 阅读全文
摘要:
最近想做一个Ajax分页功能,网上一搜几乎全是基于某某框架的Ajax分页,要么需给页面加上 scriptManager /scriptManager,要么需引入某dll,要么需使用类似于jQuery的框架。使用如上方法确实可以实现Ajax分页效果,但我总觉得不够简洁,这里写一些我的简单总结。开始进入Ajax分页功能的无框架实现方法的正题。首先创建前台页面MyAjaxPager.aspxAjax分页功能的无框架实现的画面很简单,就是一排index地址,当点击链接后会以ajax的方式将数据绑定到下边的repeater。498)this.style.width=498;" height=3 阅读全文
摘要:
htmlheadmeta http-equiv="Content-Type" content="text/html; charset=gb2312" /titleAjax提示框/titlestyle type="text/css"a{ color:#000; font-size:12px;text-decoration:none}a:hover{ color:#900; text-decoration:underline}body{background:;filter:progid:DXImageTransform.Microsoft.Gradient(gradient 阅读全文
摘要:
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"html xmlns="http://www.w3.org/1999/xhtml"headtitleAjax弹出式无刷新城市选择特效/titlemeta http-equiv="content-type" content="text/html;charset=gb2312"style type="text/css"BODY {FON 阅读全文
摘要:
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"html xmlns="http://www.w3.org/1999/xhtml"headmeta http-equiv="Content-Type" content="text/html; charset=gb2312" /title基于层的网页弹出提示,可移动,网页变灰-//titlestyle type="text/css" 阅读全文
摘要:
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"html xmlns="http://www.w3.org/1999/xhtml"headmeta http-equiv="Content-Type" content="text/html; charset=gb2312" /title始终居中的弹出层/titlestyle type="text/css"!--html,body 阅读全文
摘要:
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"html xmlns="http://www.w3.org/1999/xhtml"headtitleDIV弹出层/titlemeta charset="gbk" /stylediv{position:absolute;top:0;left:0;background:#ccc;}/style/headbodydiv id 阅读全文