batch queries SqlServer vs Oracle

[Kris Desmadryl]

SqlServer allows multiple sqlstatements in one SqlCommand by using ';'
This can for instance be used for refreshing after an insert statement or
for filling mutiple datatables with one command.

I don't think Oracle can do this, I hope I'm wrong...

Kris.

 

[Frans Bouma [C# MVP]]

SqlServer allows multiple sqlstatements in one SqlCommand by using ';'
This can for instance be used for refreshing after an insert statement or
for filling mutiple datatables with one command.

I don't think Oracle can do this, I hope I'm wrong...

Oracle can do this, but Oracle is removing the possibility from the
..NET providers, starting with the 10g provider and the new 9i providers
will have this too if I'm not mistaken.

In other words: don't batch statements.

Frans.

--

 

[Kris Desmadryl]

Are you kidding ?
Microsoft recommend to use this, to reduce roundtrips.
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenetcheck01.asp

Kris.

 

[Guest]

Or don't use Oracle ;-)

Oracle can do this, but Oracle is removing the possibility from the
..NET providers, starting with the 10g provider and the new 9i providers
will have this too if I'm not mistaken.

In other words: don't batch statements.

Frans.

--