I've been wondering if OleDBCommand doesn't supports multiple queries execution then why ";" is used in it ?
Asked
Active
Viewed 376 times
1 Answers
1
The semi-colon is the SQL statement terminator. A single statement should be terminated as well, although most parsers don't require it. More info here.
Community
- 1
- 1
Hans Passant
- 922,412
- 146
- 1,693
- 2,536
-
Yes it is a terminator indeed. But I think ";" isn't meant to be used with OleDBCommand, but is supported by the engine? – smartali89 May 01 '10 at 20:23
-
Erm, yes. OleDbCommand generates SQL statements for the engine. – Hans Passant May 01 '10 at 20:40