36 lines
681 B
Transact-SQL
36 lines
681 B
Transact-SQL
--select spid,hostname,last_batch,status,program_name
|
|
--from sysprocesses
|
|
--where hostname='SISI5SSD1'
|
|
--order by hostname
|
|
set nocount on
|
|
declare @SQLDatabase nvarchar(10)
|
|
declare @Result nvarchar(max)
|
|
set @Result='['
|
|
|
|
declare CCF cursor local fast_forward for
|
|
select t1.SQLDatabase
|
|
from pcs_whs.dbo.CustomersFrom t1
|
|
where t1.Active=1
|
|
order by t1.SQLDatabase
|
|
open CCF
|
|
fetch next from CCF into @SQLDatabase
|
|
while @@FETCH_STATUS=0
|
|
begin
|
|
if @Result='['
|
|
begin
|
|
set @Result+='"'+@SQLDatabase+'"'
|
|
end
|
|
else
|
|
begin
|
|
set @Result+=',"'+@SQLDatabase+'"'
|
|
end
|
|
fetch next from CCF into @SQLDatabase
|
|
end
|
|
close CCF
|
|
deallocate CCF
|
|
set @Result+=']'
|
|
|
|
select @Result
|
|
|
|
|