[dba-SQLServer] DoEvents equivalent

Bobby Heid bheid at sc.rr.com
Fri Jun 25 18:12:22 CDT 2010


John,

Does putting "Go" in between each set of queries give you what you want?

Bobby


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-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: [dba-SQLServer] 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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list