select * from Openrowset('MICROSOFT.JET.OLEDB.4.0','Text;HDR=YES;DATABASE=D:/',a#txt)
/*****
Author : william
Date : 2006-10-09
function: Sorting and removes repeatedly
*****/
select DISTINCT *
from Openrowset('MICROSOFT.JET.OLEDB.4.0','Text;HDR=YES;DATABASE=c:/',[phrase-list#txt])
order by 1
-- old records
/******
功能:去除txt文件中带有.com | .net | .cn ..的文件。
同时过滤相同的纪录。
2006-10-23
***/
select DISTINCT *
from Openrowset('MICROSOFT.JET.OLEDB.4.0','Text;HDR=YES;DATABASE=c:/',[phrase-list#txt])
where Address not in (
select *
from Openrowset('MICROSOFT.JET.OLEDB.4.0','Text;HDR=YES;DATABASE=c:/',[phrase-list#txt])
where charIndex('.',Address) > 0
OR charIndex('@',Address) > 0
)
order by 1