22,300
社区成员




DECLARE @OLE INT
DECLARE @FileID INT
EXECUTE sp_OACreate 'Scripting.FileSystemObject', @OLE OUT
EXECUTE sp_OAMethod @OLE, 'OpenTextFile', @FileID OUT, @File, 8, 1
EXECUTE sp_OAMethod @FileID, 'WriteLine', Null, @Text
EXECUTE sp_OADestroy @FileID
EXECUTE sp_OADestroy @OLE
SELECT LEN(@sql)
看看结果是什么?SET @sql='INSERT INTO [UFDATA_'+@books+CAST('_2017]..Inventory (中间省略5900个字符
iOverlapDay,bPiece,bSrvItem,bSrvFittings,fMaxSupply,fMinSplit,bSpecialOrder,bTrackSaleBill,cInvMnemCode FROM [UFDATA_' AS NVARCHAR(max))
把超过5900的字符进行下转换,,或者你把这5900个字符分成2段,然后用+号连接