SET NOCOUNT ON DECLARE @CurrentRow INT DECLARE @TotalRows INT DECLARE @DatabaseName NVARCHAR(255) SELECT @CurrentRow = 1 DECLARE @Databases TABLE( UNIQUEROWID INT IDENTITY ( 1,1 ) PRIMARY KEY NOT NULL ,DATABASENAME NVARCHAR(255) ) INSERT INTO @Databases (DATABASENAME) SELECT NAME FROM SYS.DATABASES WHERE DATABASE_ID > 4 SELECT @TotalRows = COUNT(* ) FROM @Databases WHILE @CurrentRow <= @TotalRows BEGIN SELECT @DatabaseName = DATABASENAME FROM @Databases WHERE UNIQUEROWID = @CurrentRow PRINT @DatabaseName SELECT @CurrentRow = @CurrentRow + 1 END
Saturday, 5 January 2008
Database Loop - WITHOUT CURSOR
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment