sql command

  1. T

    INSERT INTO with multiple rows without Select?

    I just got this error: Normaly in SQL you can do INSERT INTO (columns_list) VALUES (values for row1), (values for row2) ... I looked up the docs and theres the possiblity to insert rows from a subselect or something. Is there no way to just put 2 rows with one statement...
  2. R

    Openedge 11.7 returns different result for COUNT(DISTINCT <ColumnName>) when compared to Oracle/MSSQL

    Hi everyone, I am facing a problem that has left me a little stumped. Any help or insight will be very helpful. A table called Staples in TestV1 schema was loaded in Oracle, MSSQL and Openedge. There is a customer bug stating that a SQL query to extract a table's data in Openedge 11.1 is...
  3. Razack

    Sql Explorer Sql Command End Of Statement

    Sqlexp doesn't recognize multiple sql commands with ";" . For e.g sqlexp -db Dbname -S 1030 -char -command "CREATE USER 'dummy', '123456'" Works...... sqlexp -db Dbname -S 1030 -char -command "CREATE USER 'dummy', '123456'; grant DBA to dummy; commit;" Doesn't work
Top