分页语句

1.ie6下margin是两倍:
display:inline;
2.ie6下li标签之间有空隙：
在li下加float：left；

 

删除重复记录
delete from Users
where [Uid] not in
(
select MAX([Uid]) as s
from Users
group by UName,UPwd
)
按月份查询
select * from Works where DATEPART(m,[WUpLoadTime])=1
最近一周的记录
select * from Works where datediff(d,WUpLoadTime,getdate())<7

 

dom获得select的文本

this.options[this.selectedIndex].text

$("#zhiye").change(function () {
alert($(this).find('option:selected').text());
})

ajax get请求防止返回整个页面
在返回前加了句request.getParameter("name");

new Date().getTime();

分页
select * from (select row_number() over(order by id) * from tablename as rownum) as t where rownum>n1 and rownum<=n2

truncate table

查询 31-40条数据

select top 10 * from A where id not in(select top 30 * from A)

分页 多表查询

select * from
(

select ROW_NUMBER() Over(order by Wid desc) as rowId ,*

FROM
(

SELECT Works.*, Users.UName FROM Works,Users where Works.[Uid] = Users.[Uid]

)as A

) as T

where rowId between 1 and 10