跨平台SQL语句模版 － SQL Server, MySQL, Oracle

It is essential to understand the details of the databases underlying the applications you work with; to know what happens to whichtables when you perform an action in your application. No matter howslick your SQL skills are, walking into a new situation with unfamiliardatabases is only going to make that task trickier; and most largecompanies - and many small ones, too - will have a heterogeneousdatabase environment, unless you are very fortunate. Mixtures of SQLServer and Oracle are fairly common, and every database type will havedifferent structures and different syntax to remember.

 

http://www.simple-talk.com/dotnet/.net-tools/a-unified-approach-to-multi-database-query-templates/?utm_source=simpletalk&utm_medium=email&utm_content=QueryTemplates120091102&utm_campaign=.NET