Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

native sql for the database MS SQL

Former Member

‎2009 Nov 19 10:50 AM

0 Likes
461

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

2 REPLIES 2
Read only

Former Member

‎2009 Nov 19 4:01 PM

0 Likes
432

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

Read only

Former Member

‎2009 Nov 19 7:53 PM

0 Likes
432

TRY WHIT THIS

EXEC SQL.

TRUNCATE TABLE ZTVTAXDEPTO

ENDEXEC.

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