Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
use [master] go -- Declare container variabels for each column we select in the cursor declare @databaseName nvarchar(128) -- Define the cursor name declare DBCursor cursor -- Define the dataset to loop for select [name] from sys.databases where [name] in ('prhiscpdconfig','prraspdconfig') -- Start loop open DBCursor ------ Get information from the first row fetch next from DBCursor into @databaseName ---- Loop until there are no more rows while @@fetch_status = 0 begin Insert into DEANA (MCTR_ENTITY, MCTR_TYPE, MCTR_VALUE, MCTR_DESC, MCTR_FILTER, MCTR_VALUE_SIZE, MCTR_SORT, MCTR_LOCK_TOKEN, ATXR_SOURCE_ID) Values ('CSTK', 'CATG', 'PB07', 'SPAP/ADAP', 'PCOB', 0, 0, 1, '1753-01-01') -- Get information from next row fetch next from DBCursor into @databaseName end -- End loop and clean up close DBCursor deallocate DBCursor go
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.