22,210
社区成员
发帖
与我相关
我的任务
分享
declare @SiteIP varchar(50)
declare @SitePort varchar(50)
declare @LoginName varchar(50)
declare @loginPwd varchar(50)
declare @n int,@rows int
select @rows =(select COUNT(id) from dbo.site )--查出所客户机模式的IP
set @n=1
while @n<=@rows
begin
set @SiteIP=(select SiteIP from dbo.site )
set @SitePort=(select SitePort from dbo.site )
set @LoginName=(select LoginName from dbo.site )
set @loginPwd=(select loginPwd from dbo.site)
--执行存储过程
select @sql='exec SP_UpDataToServ '+@SiteIP+','+@LoginName+','+@loginPwd+'' --执行存储过
print (@SiteIP)
select @n=@n+1
end
select @sql='exec SP_UpDataToServ '''+@SiteIP+''','''+@LoginName+''','''+@loginPwd+''';' --执行存储过
set @SiteIP=(select SiteIP from dbo.site where ID=@i)
否则用CURSOR操作
DECLARE @SiteIP varchar(50)
declare @SitePort varchar(50)
declare @LoginName varchar(50)
declare @loginPwd varchar(50)
declare @n int,@rows int
DECLARE cur CURSOR FOR
SELECT SiteIP,SitePort,LoginName,loginPwd from dbo.site
OPEN cur
FETCH NEXT FROM cur INTO @SiteIP,@SitePort,@LoginName,@loginPwd
WHILE(@@FETCH_STATUS=0)
BEGIN
--执行存储过程
SELECT @sql='exec SP_UpDataToServ '+@SiteIP+','+@LoginName+','+@loginPwd+'' --执行存储过
print (@SiteIP)
FETCH NEXT FROM cur INTO @SiteIP,@SitePort,@LoginName,@loginPwd
END
CLOSE cur
DEALLOCATE cur