Welcome
Guest
, you are in:
<root>
•
Anmelden
CP Wiki
Navigation
¶
CP Solutions
Startseite
domizil+
Startseite
Administration
Administration
Neue Seite
Alle Seiten
Kategorien
Navigations-Pfade
Datei Manager
Neuer Benutzer
Suche im wiki
»
Zurück
Cursor Alternative
Modified on 10/06/2009 15:56
by Manuel Siebert
Categorized as
Nicht kategorisiert
((([image| |http://www.cp-austria.at/website/DesktopModules/Wiki/images/Home.gif|MainPage] » [MainPage|Startseite] » [netFramePlattform|netFrame als Plattform Menü] » [TippsundTricks|Tipps und Tricks] » Cursor Alternative | {searchbox} [Search.aspx?FullText=1|Erweiterte Suche]))) {BR} <code sql>DECLARE @query VARCHAR(100), @dbname sysname DECLARE BadCursor CURSOR FOR SELECT name FROM sys.databases WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb') OPEN BadCursor FETCH NEXT FROM BadCursor INTO @dbname WHILE @@FETCH_STATUS = 0 BEGIN SELECT @query = 'dbcc checkdb(' + quotename(@dbname) + ')' EXEC (@query) FETCH NEXT FROM BadCursor INTO @dbname END CLOSE BadCursor DEALLOCATE BadCursor GO</code>{br}{br} Noch ein kleines Beispiel für das Erstellen einer Tabelle.{br}{br} <code sql>DECLARE @query VARCHAR(100), @dbname sysname DECLARE @dblist TABLE(dbname sysname) INSERT INTO @dblist(dbname) SELECT name FROM sys.databases WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb') WHILE (SELECT count(*) FROM @dblist) > 0 BEGIN SELECT top 1 @dbname = dbname FROM @dblist SELECT @query = 'dbcc checkdb(' + quotename(@dbname) + ')' EXEC(@query) DELETE FROM @dblist WHERE dbname = @dbname END GO</code>
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.