[AccessD] DoEvents equivalent

Take a look here, John..

http://www.sqlservercentral.com/articles/Advanced+Querying/doevents/784/

You'll need to register (free) if you don't already use that site.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, June 23, 2010 9:34 AM
To: Sqlserver-Dba; Access Developers discussion and problem solving
Subject: [AccessD] DoEvents equivalent

Is there a DoEvents equivalent in SQL Server?

I perform a set  of update queries (dynamic SQL) in a cursor, printing a status for each loop of the cursor.  The stuff prints but only when the entire thing finishes.  I would like to print the results as each update occurs.

--
John W. Colby
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com