Here are some SQL programming guidelines and best practices we collected, keeping quality, performance and maintainability in mind. This list is not complete at this moment, and will be constantly updated.
Read more →
This is an article in the series that we talking about translate SQL query among different databases.
This article focus on the translation of number datatype between oracle and SQL Server database.
Read more →
Datatypes translation is one of the most important things you need to consider when migrate your application from one database to the other. This is an article in the series that we talking about translate SQL query among different databases.
Read more →
As a sql developer, DBA. we often post sql code on our blog. Take this sql for example,
select pub_name, count(qty) as orders, sum(qty) as total from sales inner join titles on (sales.
Read more →