Welcome to Burgess's blog

本博除非注明，均是原创，您若转载，请指明出处，谢谢配合！
博客园 首页 新随笔 联系 订阅 管理

2008年9月24日 #

To import data from excel to DB
摘要： 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 阅读(2819) 评论(2) 推荐(0)

sp_configure
摘要： 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 阅读(622) 评论(0) 推荐(0)