Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Wed, 7 Nov 2007 13:12:15 +0100,    group: microsoft.public.sqlserver.odbc        back       


Fetching data problem....   
Hi,
When I'm using ODBC SQLFetch method in my code it retrieves data using
database cursor. In fact it calls sp_opencursor in DB. Is it possible to
retrieve data without using cursor? What is the fastest way to fetch data?
I'm afraid of using cursor because of the performance. Do you have any
suggestion? (I'm using SQL Server 2000).

Regards,
Radek
date: Wed, 7 Nov 2007 13:12:15 +0100   author:   Rami

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us