我希望使用ssis包删除目标服务器(Postgres)表数据中的数据。database : postgres server in execute sql task :scriptis: delete from emp and connectionused odbc
当我在ssis包中运行executesql任务时,如果emp表有数据,那么它的工作正常,当emp表没有数据时,我会得到错误。“可能的失败原因:查询出现问题、"ResultSet“属性未正确
我正在编写一个查询,以便从school_images表中获取unique school_id order by最新的school id。这是我的问题。select school_id, id from school_images group by id order by id descid integer primary keyselect school_id, id order by id desc
query_ranges(box boxndf, ts timestamp, te timestamp); INSERT INTO query_ranges SELECTsomething;t = clock_timestamp(); SELECT * FROM query_rangesLOOP
select count(*) from data_table where something into