How to execute multiple query or script in sql management studio?

Question

Question

Vivek Nayak · Sep 6, 2019

#Management Portal #SQL #Caché #InterSystems IRIS

I want to insert multiple records in the table using below queries, but it gives an error.

Discussion (3)0

Log in or sign up to continue

Robert Cemper · Sep 6, 2019

Insert into LISDB.State (short,long) SELECT 'AL','Alabama' Union All SELECT 'AK','Alaska' Union All SELECT 'AZ','Arizona' Union All SELECT 'AR','Arkansas'

1 0

score 0 · Answer 1 · 2020-06-09T18:00:42-04:00

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.

score 1 · Answer 2 · 2020-06-15T03:12:48-04:00

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