I'd like use insert into location in my script. But I get some syntax errors.
What are wrongs below script?
sql('IQ_DATASTORE', 'insert into finance.Selcuk_agent_table LOCATION 'StandByDB.mydb' {select * from mydb.dbo.agent_table}');
I think it results from ' and { characters. How to cope these?