导读：动态语句,bulkinsert的from子句只能使用常量. CREATEproctest @fnvarchar(50) as declare@pathvarchar(100) set@path=..
动态语句, 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
更多文章请关注《万象专栏》
转载请注明出处：https://www.wanxiangsucai.com/read/cv149297