Have a problem with using cursors in SQL server enterprise manager

T

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
 
R

Rhys Gravell

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

SELECT COALESCE(element_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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top