测试：
Script：
create table #Test ( Name nvarchar(10), Age int, T nvarchar(10) ) BULK INSERT #Test From ‘I:\AAA.csv‘ with( fieldterminator = ‘,‘, rowterminator = ‘\n‘ ) select * from #Test drop table #Test
Result：
Name Age T
TestA 13 Aug
TestB 14 App
TestC 15 Jus
原文：http://www.cnblogs.com/chenyongblog/p/4379283.html