mssql server 存储过程里，bulk insert table from ''路径+文件''，路径固定，文件名不固定的实现方法
网络编程
动态语句, bulk insert的from 子句只能使用常量.
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
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
编辑：一起学习网
标签：子句,常量,语句,动态,ROWTERMINATOR