导出数据.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 3 行

use elcharge
insert into openrowset('MicroSoft.Jet.OleDB.4.0','Excel 5.0;HDR=yes;Database=f:\sqldata\aa.xls','select * from [sheet1$]')
select * from openrowset('sqloledb','4BB8377715894B6';'sa';'sa',elcharge.dbo.ec) where date = '2008-4-16'