i need to execute or submit multiple commands at the same time without waiting for each command to complete in sql server 2000 or 2005. please help me.
i need to execute or submit multiple commands at the same time without waiting for each command to complete in sql server 2000 or 2005. please help me.
Of course that will still execute the selected commands serially. For truly concurrent executions you would need to run different sessions - ie: multiple query windows. I don't know of a way to run concurrent code from the same window.
In your client application you can create multiple threads and execute concurrent commands on different threads.
I would also look at BeginExecuteNonQuery and BeginExecuteReader for starting aysnc requests from the client.
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx
No one has followed this question yet.