Loop through records without using a cursor

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

WHILE@objName IS NOT NULL
BEGIN
SELECT @objName = MIN( Name )
FROMSysObjects
WHEREType='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 )
FROMSysObjects
WHEREType='V' AND
Name > @objName

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

WHILE@objName IS NOT NULL
BEGIN
SELECT @objName = MIN( Name )
FROMSysObjects
WHEREType='U' AND
Name > @objName

IF@objName IS NOT NULL
exec sp_recompile @objNameEND