Question Vivek Nayak · Sep 6, 2019 How to execute multiple query or script in sql management studio? #Management Portal #SQL #Caché #InterSystems IRIS I want to insert multiple records in the table using below queries, but it gives an error. 0 0 2,598
Robert Cemper · Sep 6, 2019 Insert into LISDB.State (short,long)SELECT 'AL','Alabama'Union AllSELECT 'AK','Alaska'Union AllSELECT 'AZ','Arizona'Union AllSELECT 'AR','Arkansas' Evgeny Shvarov · Jun 9, 2020 Suppose you have your sql script in script.sql You can call the following command: do $System.SQL.DDLImport("IRIS",$Username,"/path/script.sql") It will execute all the lines one-by-one. Learn more in documentation. Mathew Lambert · Jun 15, 2020 There is no pretty way to do it via management portal. Either use a JDBC tool like squirrel or sql workbench, or use an sql file with do $System.SQL.DDLImport
Evgeny Shvarov · Jun 9, 2020 Suppose you have your sql script in script.sql You can call the following command: do $System.SQL.DDLImport("IRIS",$Username,"/path/script.sql") It will execute all the lines one-by-one. Learn more in documentation. Mathew Lambert · Jun 15, 2020 There is no pretty way to do it via management portal. Either use a JDBC tool like squirrel or sql workbench, or use an sql file with do $System.SQL.DDLImport
Mathew Lambert · Jun 15, 2020 There is no pretty way to do it via management portal. Either use a JDBC tool like squirrel or sql workbench, or use an sql file with do $System.SQL.DDLImport
SELECT 'AL','Alabama'
Union All
SELECT 'AK','Alaska'
Union All
SELECT 'AZ','Arizona'
Union All
SELECT 'AR','Arkansas'
Suppose you have your sql script in script.sql
You can call the following command:
do $System.SQL.DDLImport("IRIS",$Username,"/path/script.sql")
It will execute all the lines one-by-one.
Learn more in documentation.
There is no pretty way to do it via management portal.
Either use a JDBC tool like squirrel or sql workbench, or use an sql file with do $System.SQL.DDLImport