Direct execution is the most basic way to execute a statement.
An application builds a character string containing a Transact-
SQL statement and submits it for execution using the
SQLExecDirect function. When the statement reaches the server,
SQL Server compiles it into an execution plan and then
immediately runs the execution plan. Direct execution is
commonly used by applications that build and execute statements
at run time and is the most efficient method for statements that
will be executed a single time. Its drawback with many databases
is that the SQL statement must be parsed and compiled each time
it is executed, which adds overhead if the statement is executed
multiple times. SQL Server significantly improves the
performance of direct execution of commonly executed statements
in multiuser environments and using SQLExecDirect with parameter
markers for commonly executed SQL statements can approach the
efficiency of prepared execution. When connected to an instance
of SQL Server, the SQL Server Native C