我有个serverlist.txt文件,存贮一下数据(服务器名称)
server1,server2,server3,server4,server5,server6,server7,请教高手如何用command prompt 解析输出server1
server2
server3
server4
server5
server6
server7用于sqlcmd 执行任务.提示,我用for /F "delims=," %%i in (./serverlist.txt) do echo %%i 未成功。谢谢!
server1,server2,server3,server4,server5,server6,server7,请教高手如何用command prompt 解析输出server1
server2
server3
server4
server5
server6
server7用于sqlcmd 执行任务.提示,我用for /F "delims=," %%i in (./serverlist.txt) do echo %%i 未成功。谢谢!
/*
功能:实现split功能的函数
*/create function dbo.fn_split
(
@inputstr varchar(8000),
@seprator varchar(10)
)
returns @temp table (a varchar(200))
as begin
declare @i intset @inputstr = rtrim(ltrim(@inputstr))
set @i = charindex(@seprator, @inputstr)while @i >= 1
begin
insert @temp values(left(@inputstr, @i - 1))set @inputstr = substring(@inputstr, @i + 1, len(@inputstr) - @i)
set @i = charindex(@seprator, @inputstr)
endif @inputstr <> '\'
insert @temp values(@inputstr)return
end
go--调用declare @s varchar(1000)set @s='1,2,3,4,5,6,7,8,55'select * from dbo.fn_split(@s,',')drop function dbo.fn_split