34,838
社区成员




select Name,sdate,right(min(stime),6) as time1_min,right(max(stime),6) as time1_max
from tr group by Name,sdate
--
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','路径';'用户名';'密码','SELECT * FROM 你的表') where sdate= (select max(sdate) FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','路径';'用户名';'密码','SELECT * FROM 你的表'))
--
select * form newtable
where sdate = (select max(sdate) from sdate)
--*Access
--1
SELECT * into newtable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','D:\db.mdb';'admin';'','SELECT * FROM vote')
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','路径';'用户名';'密码','SELECT * FROM 你的表')
--2
select * into newtable from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\db.mdb;Persist Security Info=False')...vote