02 2012 档案

SQL 查询某个库的所有表的行数
摘要：select a.name AS name,b.rows AS rows INTO #Temp1from db_tank(数据库名称).dbo.sysobjects a LEFT JOIN db_tank(数据库名称).dbo.sysindexes bON( a.id=b.id ) WHERE a.type='u' ORDER BY b.rows DESCSELECT name,max(rows) FROM #Temp1 GROUP BY NAME ORDER BY max(rows) DESC 阅读全文

posted @ 2012-02-24 10:59 Seven/7 阅读(381) 评论(0) 推荐(0)

C#操作EXCEL文件
摘要：读取Excel，写入Excel 1.加载Excel（读取excel内容）返回值是一个DataSetpublic static DataSet LoadDataFromExcel(string filePath) { try { string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'"; OleDbConnection Ol 阅读全文

posted @ 2012-02-10 09:15 Seven/7 阅读(2521) 评论(0) 推荐(0)

导航