Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Using Cursor for record selection....

Author  Topic 

SanjaySutar
Starting Member

18 Posts

Posted - 2008-04-02 : 02:57:33
Hi,
i want a stored procedure which returns records using a
cursor.

[Actually i want this to read records for a C#.net application].

thanx in advance

nr
SQLTeam MVY

12543 Posts

Posted - 2008-04-02 : 03:17:57
The resultset will be a cursor - you just need a select statement at the end of the SP.
The type of cursor will be defined by the client not the SP.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -