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
.png)
.png)
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