文件名称:mssql server 存储过程里,bulk insert table from ‘路径+文件’,路径固定,文件名不固定的实现方法
文件大小:24KB
文件格式:PDF
更新时间:2024-02-11 08:32:32
ab ble 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 =