huacnlee 2010-06-19 09:10
原来的请求队列限制为4000，现在无限制。
我记得 IIS6 里面好像是默认 2000 吧！
而且这个最好不要改动它，之前我有做过压力测试，2000 是最合适的
如果再大一点就会产生应用程序池关闭，或者页面打不开
当然根本的原因还是要从代码上来解决，负载大了以后，一些小的内存泄漏都会导致大问题
Lisng 2009-12-30 11:39
declare @t table (id int,name varchar(10))
insert into @t (id,name) values(1,'a')
insert into @t (id,name) values(2,'b')
insert into @t (id,name) values(3,'c')
insert into @t (id,name) values(4,'d')
/*
update @t set name+='6' from @t t inner join
(
select 1 as id union select 3 as id
)
as tmp on tmp.id=t.id
*/
delete @t from @t t inner join
(
select 1 as id union select 3 as id
)
as tmp on tmp.id=t.id
select * from @t
Lisng 2009-10-28 09:16
以上是平板（无边框）的div效果
我琢磨后给它加上了边框效果，原理是给它加上左右边框
CSS：
.rtop, .rbottom{ display:block; background:white;}
.rtop *, .rbottom *{ display:block; overflow:hidden; height:1px; background:floralwhite; border-left:1px silver solid; border-right:1px silver solid;}
.r1{margin:0 5px; border-left:2px; border-right:2px; background:silver;}
.r2{margin:0 3px; border-left:2px; border-right:2px;}
.r3{margin:0 2px;}
.r4{margin:0 1px; height:2px;}
Lisng 2009-10-28 09:13
<html>
<head>
<title>CSS圆角效果--网页教学网</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<style type="text/CSS">
div.RoundedCorner{background: #9BD1FA}
b.rtop, b.rbottom{display:block;background: #FFF}
b.rtop b, b.rbottom b{display:block;height: 1px;overflow: hidden; background: #9BD1FA}
b.r1{margin: 0 5px}
b.r2{margin: 0 3px}
b.r3{margin: 0 2px}
b.rtop b.r4, b.rbottom b.r4{margin: 0 1px;height: 2px}
</style>
</head>
<body>
<div class="RoundedCorner">
<b class="rtop"><b class="r1"></b><b class="r2"></b><b class="r3"></b><b class="r4"></b></b>
<br>无图片实现圆角框<br><br>
<b class="rbottom"><b class="r4"></b><b class="r3"></b><b class="r2"></b><b class="r1"></b></b>
</div>
</body>
</html>
果果’er 2009-08-05 14:48
"巫毒程序员"找些资料给出这样一个公式：
SELECT DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 0)
要点是用"0"这个SQL Server里的基准值来辅助计算。
另，SQL Server的周日是作为上一周的日期，所以先把日期减1来计算。
总之就是“试”出来公式看起来是正确的。
参考: http://www.aspxhome.com/database/mssql/20089/474711.htm
测试一下:
declare @d datetime
set @d = '2009-8-1 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-2 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-3 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-4 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-5 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-6 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-7 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-8 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-9 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-10 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-11 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-12 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-13 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-14 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-15 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)
set @d = '2009-8-16 3:1:2' ; SELECT @d, DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, @d) ), 0)