master..xp_cmdshell(osql命令)批量执行SQL脚本

--upScript-20 to 22
--dir /b/s >upScripts.sql
declare @a1 varchar(500)
declare @dbName varchar(100)='DB_TEST'
--select @dbName='DB_BG11'
--select @dbName='DB_BG90'
--select @dbName='DB_BG91'
declare @serverName varchar(100)='DBServer01'
declare @constOSQL varchar(2000)= 'osql -S'+@serverName+' -E -d'+@dbName+' -i'

--select @a1=@constOSQL+'D:\O2-Upgrade\UpgradeV6.2.2.0-V6.2.2.2\SQL\DATABASE\Script\18046_V6.2.2.2.sql' EXEC master..xp_cmdshell @a1