下面的存储过程出错，说@File1附近有错，我用的是sql server的(10分)

S

study2003

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-09

• #1

CREATE PROCEDURE BulkTo
@File1 varchar(300)
AS
bulk insert allfile from @File1
WITH (
FIELDTERMINATOR = ',,,'
)

GO

 

雪

雪中漫步

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-09

• #2

表名做参数不能这么用的
你可以
declare sqlstr varchar(200)
..
sqlstr:='bulk insert allfiel from '+@file1
exec(sqlstr)

 

S

study2003

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-09

• #3

如何写到在存储过程中去，谢谢

 

雪

雪中漫步

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-09

• #4

CREATE PROCEDURE BulkTo
@File1 varchar(300)
AS
declare @sqlstr varchar(200)

set @sqlstr='bulk insert allfiel from '+@file1+'WITH (FIELDTERMINATOR = '+',,,'+')'
exec(@sqlstr)
GO