bulk insert 语句T-sql

if object_id('#temp1') is not null 

drop table #temp1

go

create table #temp1(field1 nvarchar(100),

field2 float)

bulk insert #temp1 from 'd:foo.txt'

with(fieldterminator=' ',rowterminator=' ')

select * from #temp1

drop table #temp1