兄台每次问的问题都比较有难度啊,上次的也没说我回答的对不对 if exists(select 1 from sysobjects where id=object_id('test')) begin truncate table test; drop table test; end go create table test( id int ) go !!bcp mytest.dbo.test in D:\test.txt -S 192.168.1.123 -U sa -P 123 -c -t "|""" -b 20000语句之间加go 即可解决
if exists(select 1 from sysobjects where id=object_id('test'))
begin
truncate table test;
drop table test;
end
go
create table test(
id int
)
go
!!bcp mytest.dbo.test in D:\test.txt -S 192.168.1.123 -U sa -P 123 -c -t "|""" -b 20000语句之间加go 即可解决