Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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
|Excel conversion issue with Sql server||14||45|
|SQL Select - Help with CASE||4||41|
SQL 2012 update fails repeatedly : the UPdate is SQLServer2012-KB3194721-x6
|SQL - insert empty rows into output results||9||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!