declare
m_cursor
cursor
scroll
for
select
Address,PeopleId
from
PeopleDetail
open
m_cursor
declare
@Address
varchar
(50), @PeopleId
int
fetch
next
from
m_cursor
into
@Address,@PeopleId
while @@FETCH_STATUS=0
begin
print @Address +
convert
(
varchar
(3), @PeopleId)
fetch
next
from
m_cursor
into
@Address,@PeopleId
end
close
m_cursor
deallocate
m_cursor