SET @iSQL=N‘BULK INSERT [TEST].[dbo].[TEST_Interim]‘+‘ FROM ‘+quotename(@fullFileName,‘‘‘‘)+‘ WITH (BATCHSIZE=1000,FIELDTERMINATOR=‘‘\t‘‘,DATAFILETYPE=‘‘widechar‘‘,FIRSTROW=1,ROWTERMINATOR=‘‘\n‘‘,TABLOCK)‘ EXEC SP_EXECUTESQL @iSQL
原文：http://www.cnblogs.com/blossomwei/p/6923057.html