CREATE proc test
@fn varchar(50)
as
declare @path varchar(100)
set @path= 'd:\'
exec('
bulk INSERT table FROM '''+@path+@fn+'''
WITH
(
FIELDTERMINATOR = '','',
ROWTERMINATOR = ''\n''
)')
摘自CSDN
以上就是【mssql server 存储过程里,bulk insert table from '路径+文件',路径固定,文件名不固定的实现方法】的全部内容了,欢迎留言评论进行交流!