Writing ANSI Standard SQL is not practical - this is the conclusion I came to after several years of writing portable applications, which had to work against both SQL Server and Oracle. Let me elaborate. The best practice is to use stored procedures. You do not want to issue SQL directly from your application. You want to invoke stored ...