Loop through records without using a cursor

DECLARE @objName VARCHAR(50)
SET	@objName = ''

WHILE	@objName IS NOT NULL
	BEGIN
		SELECT @objName = MIN( Name )
		FROM	SysObjects
		WHERE	Type='U' AND
			Name > @objName

		IF	@objName IS NOT NULL
			BEGIN
				--	Insert code to do stuff here.
				PRINT  @objName 
			END
	END


* * *
Example to recompile all stored procs and refresh all views.

DECLARE @objName VARCHAR(50)
SET	@objName = ''

WHILE	@objName IS NOT NULL
	BEGIN
		SELECT @objName = MIN( Name )
		FROM	SysObjects
		WHERE	Type='V' AND
			Name > @objName

		IF	@objName IS NOT NULL
				exec sp_refreshview @objName		END
SET	@objName = ''

WHILE	@objName IS NOT NULL
	BEGIN
		SELECT @objName = MIN( Name )
		FROM	SysObjects
		WHERE	Type='U' AND
			Name > @objName

		IF	@objName IS NOT NULL
				exec sp_recompile @objName		END