SQL Server
-
编辑 删除
To import data from excel to DB
Here,I introduce some methods to import data from excel to DB, 1 By OPENDATASOURCESELECT * FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;D...
-
编辑 删除
How to catch SQL Statement's information quickly
You can fetch all information about SQL Statement with below SQL scirpt. Then you can analyze and improve script to boost performance.SELECT creation_time,last_execution_time,total_physica...
