Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from SQL Server to TaurusDB for PostgreSQL/ U0530004: TOP does not work in INSERT...EXEC for TaurusDB for PostgreSQL
Updated on 2025-06-07 GMT+08:00
View PDF
Share

U0530004: TOP does not work in INSERT...EXEC for TaurusDB for PostgreSQL

Description

Database Type and Version

  • Source database type and version: all SQL Server versions
  • Target database type and version: TaurusDB for PostgreSQL 16.4 and later

Syntax Example

TOP does not work in an INSERT...EXEC statement for TaurusDB for PostgreSQL, so the number of rows to be inserted cannot be limited.

SQL Server syntax:

INSERT TOP (2) INTO tab_1 (col_1, col_2, col_3) exec dbo.test_proc;

Suggestion

Adjust related functions.