Embedded SQL provides several advantages over a call-level interface:
->Embedded SQL is easy to use because it is simply Transact-SQL with some added features that facilitate using it in an application.
->It is an ANSI/ISO-standard programming language.
->It requires less coding to achieve the same results as a call-level approach.
->Embedded SQL is essentially identical across different host languages. Programming conventions and syntax change very little. Therefore, to write applications in different languages, you need not learn new syntax.
->The precompiler can optimize execution time by generating stored procedures for the Embedded SQL statements.