摘要:
--SQL CODE TO CREATE SPCreate procedure usp_ImportMultipleFiles2 @filepath nvarchar(500), @pattern nvarchar(100)asset quoted_identifier off-- Set query files under folder declare @sql nvarchar(1000)set @sql ='master.dbo.xp_cmdshell "dir '+@filepath+@pattern +' /b"'--Retriev 阅读全文