摘要: select * from (select *,ROW_NUMBER() OVER(ORDER BY(SELECT 0)) AS Rownum from employee) as table1 where table1.rownum >= 1 and table1.rownum <= 3 阅读全文
posted @ 2016-05-30 17:10 IsCarrie 阅读(163) 评论(0) 推荐(0) 编辑
摘要: public abstract class SQLHelper { //只读的静态数据库连接字符串 //需添加引用System.Configuration; public static readonly string connString = ConfigurationManager.ConnectionStrings["Connectio... 阅读全文
posted @ 2016-05-30 17:06 IsCarrie 阅读(1756) 评论(0) 推荐(0) 编辑