把文本文件數(shù)據(jù)快速導(dǎo)入Sql Server
bulk insert <tablename> from '<filepath>' with ( FieldTerminator='<ternimator>', RowTerminator='<recordend>' )比如,把 C:\aaa.txt (每行一個記錄,不同字段間以制表符分隔)里的數(shù)據(jù)導(dǎo)入 表 xxx:
bulk insert xxx from 'c:\aaa.txt'
with ( FieldTerminator='\t', RowTerminator='\n' )當(dāng)然,前提是要保證各字段的數(shù)據(jù)類型能匹配.
這種方法的優(yōu)勢是:只需要運(yùn)行Sql語句就行(不需要Management Studio);速度非常快(我的情況下,6萬多條數(shù)據(jù)只用了不到一秒).
