Tony, you are making a fool of yourself. That is not embedded SQL,
that is dynamic SQL in client code. That is not what Joe is talking
Embedded SQL is when you in the middle of a C or a COBOL program has
SELECT :hostvar1 = col, :hostvar2 = col FROM tbl
That is the point i'm trying to make and if you'd bothered to read my whole
message you might have realised instead of resulting to an insult.
MS SQL Server doesn't have a pre-processor, old legacy stuff like PL/1 and
COBOL on the mainframe against DB2 does but thats no longer a mainstream
When you develop now, if you embed SQL in the application you build a string
dynamically in the application and execute it against the database.
SQL Server MVP
(Create your own groups, Forum, FAQ's and a ton more)