Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.
PostgreSQL – Storing Unicode Characters is Easy
SQL Server needs NVARCHAR or NCHAR for non-English text. In PostgreSQL, plain VARCHAR stores Unicode characters too, as my quick Russian example shows.
PostgreSQL – Learn Online in a Single Day – PostgreSQL Learning Path
PostgreSQL is considered to be one of the most advanced open source database.In this blog post we will discuss about the PostgreSQL Learning Path.
How to Insert Multiple Rows in a Single SQL Query – Interview Question of the Week #069
Interview question: write one script that inserts multiple rows in a single SQL query and runs unchanged in SQL Server, MySQL and PostgreSQL. Here is my answer.
SQL SERVER – How to Create Linked Server to PostgreSQL?
I work with both SQL Server and PostgreSQL, and people often ask how to link them. Here are the steps to create a linked server from SQL Server to PostgreSQL.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.