difference between EMBEDDED sql and DYNAMIC sql in sql server

By j Miracle

The difference between embedded sql and dynamic sql.

the difference between the embedded and dynamic sql is as follows.

(1) the embedded means to coding the sql query in the general purpose programing language.and programmer must access to a database

from general purpose programming language its called the embedded sql.

-->the dynamic sql means component of sql allows program to construct and submit sql queries at run time it's called the dynamic sql.

(2)embedded sql statement must be completely present at the compile time.

-->while in the dynamic sql statement not present compile time only present at run time pehapes based on user input.

difference between EMBEDDED sql and DYNAMIC sql in sql server  (3693 Views)