摘要：Here, I will show how to create your favorites,the below picture is an example: 1 Inserting an Item from the SAP Standard or User Menu: 1> You can use drag and drop 2>use the menu bar: Choose an it... 阅读全文

摘要：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... 阅读全文

摘要：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 ... 阅读全文