tristone的专栏

1、在查询分析器下查询Excel文档 SELECT * FROM OpenDataSource(Microsoft.Jet.OLEDB.4.0,Data Source="c:/测试.xls"; User ID=Admin;Password=;Extended properties=Excel 8.0)...Sheet1$ 2、从数据库中导出数据并存到文件中 EXEC

1.按姓氏笔画排序: Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as 2.分页SQL语句 select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum,tab.* from 表名 As