如何开启SQLSERVER数据库缓存依赖优化网站性能

SQLServer和Oracle的常用函数对比

　　1.绝对值
　　S:select abs(-1) value
　　O:select abs(-1) value from dual
　　2.取整(大)
　　S:select ceiling(-1.001) value
　　O:select ceil(-1.001) value from dual
　　3.取整（小）
　　S:select floor(-1.001) value
　　O:select floor(-1.001) value from dual
　　4.取整（截取）
　　 ......

java数据库连接及测试(sqlserver)

package com.test.util;
import java.sql.*;
public class ConnectDB {
private Connection conn=null;
private PreparedStatement pt=null;
private ResultSet rs=null;
private String uname="sa";
private String upwd="sa";
private String url="jdbc:microsoft:sqlserv ......

CodeSmith,SqlServer,C#中的类型对照

SQLServer CodeSmith C#
bigint Int64 ......

SqlServer 的几种分页方式

方式一：
select top 200 * from view_OrganResource
where 1=1 and OrganID = 57 and
(OrderID not in(select top 1000 OrderID from tb_OrganResource
where 1=1 and OrganID = 57 order by uploadtime desc))
order by uploadtime desc --5858 1980
方式二：
select top 200 * from
vi ......

SQLSERVER 分页

select identity(int,1,1) as col_id , * into temp from uep.dbo.A_experiment
select * from temp where col_id between 50 and 60
drop table temp ......