Cursors On Sql Server 2005

DECLARE @TableName VARCHAR(2000)

DECLARE db CURSOR FOR
SELECT name
FROM sysobject
WHERE xtype = 'u'

OPEN DB
FETCH NEXT FROM db INTO @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
 PRINT @TableName
 FETCH NEXT FROM db INTO @TableName
END

CLOSE db
DEALLOCATE db

Declare @row int
Declare @CODE varchar(10) 
Declare @VN varchar(50) 
Select @row = acode from  Tblmst_Serial
DECLARE CU CURSOR FOR SELECT TYP,VNAME FROM Tblmst_Serial
  OPEN CU
    while(@row >0)  // alternative we can Also Use here "While(@@fetch_status<>0)"
		begin
		fetch next from CU into @CODE,@VN
		print @CODE
		print @VN
		 Set @row =@row -1
		end
   Close CU
 Deallocate CU