![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
文章平均质量分 54
A873054267
这个作者很懒,什么都没留下…
展开
-
sql server2008 分页。分段查询
SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY postime) AS RowNumber FROM day1101) day1101 WHERE RowNumber > 100 AND RowNumber <= 200 ORDER BY postime 其中day1101为表名,postime为排序字段...原创 2018-10-28 16:39:07 · 185 阅读 · 0 评论 -
C#连接sql server并读取表数据
引入sql客户端的dll using System.Data; using System.Data.SqlClient; SqlConnection con = new SqlConnection(); // con.ConnectionString = "server=505-03;database=ttt;user=sa;pwd=123"; ...原创 2018-10-27 22:02:11 · 6903 阅读 · 0 评论 -
sqlserver直接返回表的记录数,行数
sql="SELECT rows FROM sysindexes WHERE id = OBJECT_ID('day1101') AND indid < 2" 可以直接返回不用进行rowcount等操作,原创 2019-04-11 15:46:55 · 4404 阅读 · 0 评论