摘要: --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 阅读全文
posted @ 2012-05-04 21:15 mjg 阅读(327) 评论(0) 推荐(0) 编辑