Welcome to Burgess's blog

本博除非注明,均是原创,您若转载,请指明出处,谢谢配合!

博客园 首页 新随笔 联系 订阅 管理

2008年9月24日 #

摘要: Here,I introduce some methods to import data from excel to DB, 1 By OPENDATASOURCE SELECT * FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DataBase=D:\TEST.xls')...[sheet1$] Not... 阅读全文
posted @ 2008-09-24 17:26 Burgess 阅读(2810) 评论(2) 推荐(0) 编辑

摘要: sp_configure is an useful SP, and we can display or change global configuration settings for the current server with it. By default, you can't display advanced options when executing sp_configure. To ... 阅读全文
posted @ 2008-09-24 17:00 Burgess 阅读(609) 评论(0) 推荐(0) 编辑