Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-06-30 : 07:13:19
|
| how can i run parallel sql statemnt?INSERT INTO DestinationTableASELECT * FROM SourceTablAINSERT INTO DestinationTableBSELECT * FROM SourceTablB |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-06-30 : 07:16:25
|
| Highlight all the codes and runMadhivananFailing to plan is Planning to fail |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-06-30 : 09:11:49
|
You can't. The two queries are run in serial, ie the first query has to finish before second query begins.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2010-06-30 : 09:26:34
|
| You could look at using Service Broker. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-07-01 : 01:35:18
|
| so how yiu can run two orders in parallel.what do you mean service broker? (service broker is not like replication?) |
|
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2010-07-01 : 05:17:11
|
| http://msdn.microsoft.com/en-US/library/ms166043(v=SQL.90).aspx |
|
|
|
|
|
|
parralel sql statment