» Transact SQL
» ANSI SQL
» Database Unit Testing (RSS)
Sorry, but there are no more tags available to filter with.
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 ...