使用BULK INSERT 用法如下: stu.txt 结构 1,Jim 2,Kate 3,Tom ... BULK INSERT dbo.TABLE1 FROM 'd:\stu.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) 查看table1里的数据 select * from table1 就ok了。 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 15:20 , Processed in 0.164828 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.