Have a problem with using cursors in SQL server enterprise manager

[TaeHo Yoo]

Have a problem with using cursors in SQL server enterprise manager.
My code sql query is followed
---------------------------------------
DECLARE @element_name varchar(100)
DECLARE elements_cursor CURSOR FOR
SELECT element_name
FROM KB_Element_Ref

OPEN elements_cursor
FETCH NEXT FROM elements_cursor INTO @element_name

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @element_name
FETCH NEXT FROM elements_cursor INTO @element_name
END

CLOSE elements_cursor
DEALLOCATE elements_cursor
------------------------------------------------------------
I have more than 100 rows int KB_Element_Ref table.
but when I execute this query, it said only a row has affected and did't
print any element_name.
does any one know what is going on?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Vaclav Jedlicka]

your code is correct

are you sure the table is not empty?

Vaclav

"TaeHo Yoo" <an*******@devd ex.com> wrote in message
news:uN******** ******@TK2MSFTN GP10.phx.gbl...

Have a problem with using cursors in SQL server enterprise manager.
My code sql query is followed
---------------------------------------
DECLARE @element_name varchar(100)
DECLARE elements_cursor CURSOR FOR
SELECT element_name
FROM KB_Element_Ref

OPEN elements_cursor
FETCH NEXT FROM elements_cursor INTO @element_name

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @element_name
FETCH NEXT FROM elements_cursor INTO @element_name
END

CLOSE elements_cursor
DEALLOCATE elements_cursor
------------------------------------------------------------
I have more than 100 rows int KB_Element_Ref table.
but when I execute this query, it said only a row has affected and did't
print any element_name.
does any one know what is going on?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Rhys Gravell]

Try
<CODE>
DECLARE @element_name varchar(100)
DECLARE elements_cursor CURSOR FOR SELECT element_name FROM
KB_Element_Ref

SELECT COALESCE(elemen t_name,'Null Value') FROM KB_Element_Ref

OPEN elements_cursor
FETCH NEXT FROM elements_cursor INTO @element_name
WHILE @@FETCH_STATUS = 0

BEGIN
PRINT '<<' + @element_name + '>>'
FETCH NEXT FROM elements_cursor INTO @element_name
END

CLOSE elements_cursor
DEALLOCATE elements_cursor
</CODE>

in query analyzer to help check if a zero length string, or null is
being returned.
Rhys Gravell

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!