http://www.cs.sfu.ca/CourseCentral/354/zaiane/material/notes/Chapter4/node33.html
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.