As we all know, Microsoft officially released SQL Server 2012 RC0. You can register and download the binaries from http://www.microsoft.com/sql.
As with every new release, Microsoft added more features and enhancements, improvements not only to the SQL Server database engine but also to other features in SQL Server.
Some of the improvements that Microsoft did are on Transaction SQL.
In this article, I am going to illustrate some of the new functions that are introduced in SQL Server 2012. They are related to the DATE and LOGICAL functions.
The first function I want to discuss is related to the date function as it relates to concatenating different numerical date parts and changes the data type to date time. Let us run the following example code. Read more »

A veces queremos ejecutar un SQL dentro de una función (como en un trigger) en el que los nombres de los campos o de la tabla a consultar varian, es decir que es dinámico.
Si estamos usando el lenguaje procedimental de PostgreSQL (PL/pgSQL), esto puede hacerse a través de concatenación de cadenas de texto. Read more »

A veces es necesario poder copiar datos entre diferentes bases de datos, que incluso pueden residir en diferentes servidores. Postgresql proporciona una librería interesante para poder realizar dicho cometido. Read more »