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
view_OrganResource where organid=57 and
uploadtime <
(
select min(uploadtime)
from
(
select top 1000 uploadtime from view_OrganResource where organid=57 order by uploadtime desc
) a
)
order by uploadtime desc
方式三：
SELECT ROW_NUMBER() OVER(ORDER BY orderid DESC) AS 'rnum',*
from view_OrganResource
WHERE 1=1 and rnum >1 and rnum < 1000
SELECT TOP 200 * from (SELECT
ROW_NUMBER() OVER (ORDER BY uploadtime desc) AS RowNumber,
*
from
dbo.view_OrganResource) _myResults
WHERE
RowNumber > 1000
方式四：
SELECT * from (SELECT
ROW_NUMBER() OVER (ORDER BY uploadtime desc) AS RowNumber,
*
from
dbo.view_OrganResource) _myResults
WHERE
RowNumber between 1000 and 1200
go
方式五：
WITH OrderedResults AS
(SELECT *, ROW_NUMBER() OVER (order by uploadtime desc) as RowNumber from dbo.view_OrganResource)
SELECT *
from OrderedResults
WHERE RowNumber between 1001 and 1200
方式六：
BEGIN
DECLARE @PageLowerBound int
DECLARE @PageUpperBound int
-- Set the page bounds
&n
相关文档：
在 SQLServer2005 中对 XML 的处理功能显然增强了很多，提供了 query(),value(),exist(),modify(),nodes() 等函数。
关于 xml ，难以理解的不是 SQLServer 提供的函数，而是对 xml 本身的理解，看似很简单的文件格式，处理起来却是非常困难的。本文只是初� ......
JAVA 连接 SQLServer 2000 所需要的三个JAR包。
http://download.csdn.net/source/2283940
----------------
Code:
------------------------
Connection conn = null;
Statement sta = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServer ......
一 测试环境
一 测试环境
操作系统 Red Hat As 2.1
数据库 SQLServer2000 installed in windows xp professional，我假定数据库有用户autotest 密码是autotest，数据库文件是atsdb
注意： &n ......
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 ......
上次做了个项目，涉及到数据库的还原和恢复，到网上找了一下，是利用SQLDMO实现的，只要添加SQLDMO引用就好了，然后利用下边的类的方法就可以实现了。
我把原作者的类扩充了一下，可以自动识别web.config里 的数据库连接字符串，可以通过变量设置还原恢复的信息。
需要注意的时还原，还原的时候问� ......
