native sql for the database MS SQL

[Former Member]

Hi All,

How can we write native sql ( stored procedures ) when the database is MS SQL.

Please let me know your ideas on this.

Thanks,

Sreedhar

[Former Member]

TRY WHIT THIS

EXEC SQL.

TRUNCATE TABLE ZTVTAXDEPTO

ENDEXEC.

ALL CODE BETWEN EXEC SQL. AND ENDEXEC. ARE NATIVE SQL

[Former Member]

It isn't a good idea because your syntax depends on syntax of MS SQL. In a future the database can change and this code willn't be valid.

ABAP SQL is more limited than MS SQL

[Former Member]

TRY WHIT THIS

EXEC SQL.

TRUNCATE TABLE ZTVTAXDEPTO

ENDEXEC.

ALL CODE BETWEN EXEC SQL. AND ENDEXEC. ARE NATIVE SQL