topic native sql for the database MS SQL in Application Development and Automation Discussions

native sql for the database MS SQL

Former Member — Thu, 19 Nov 2009 10:50:47 GMT

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 — Thu, 19 Nov 2009 16:01:56 GMT

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 — Thu, 19 Nov 2009 19:53:11 GMT

TRY WHIT THIS

EXEC SQL.

TRUNCATE TABLE ZTVTAXDEPTO

ENDEXEC.

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