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.
asked
how to submit simultaneous commands in sql server
Select all code and hit F5
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
