34,576
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #T(filename nvarchar(1024));
INSERT #T EXEC xp_cmdshell N'dir C:\T_SQL_Script /b';
DELETE #T WHERE filename IS NULL;
DECLARE @FILENAME NVARCHAR(1024);
DECLARE cur CURSOR FOR
SELECT filename FROM #T;
OPEN cur;
DECLARE @sql NVARCHAR(1000);
FETCH NEXT FROM cur INTO @FILENAME;
WHILE @@FETCH_STATUS=0
BEGIN
SET @sql=N'sqlcmd -E -SinstanceName -i'+@FILENAME;
EXEC xp_cmdshell @sql;
FETCH NEXT FROM cur INTO @FILENAME;
END
CLOSE cur;
DEALLOCATE cur;