In the mssqlserver stored procedure, bulkinserttablefrom ''path + Text

In the mssqlserver stored procedure, the bulkinserttablefrom path + file has fixed paths and the file name is not fixed.

In the mssql server Stored Procedure, bulk insert table from ''path + file', fixed path, and unfixed file name Implementation Method

Dynamic statement. The from clause OF bulk insert can only use constants.
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''
)')




From CSDN