A873054267的博客

SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY postime) AS RowNumber FROM day1101) day1101WHERE RowNumber > 100 AND RowNumber <= 200 ORDER BY postime其中day1101为表名，postime为排序字段...

     引入sql客户端的dllusing System.Data;using System.Data.SqlClient;SqlConnection con = new SqlConnection();            // con.ConnectionString = "server=505-03;database=ttt;user=sa;pwd=123";       ...

sql="SELECT rows FROM sysindexes WHERE id = OBJECT_ID('day1101') AND indid < 2"可以直接返回不用进行rowcount等操作，