ERP | Dataprix TI

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by

The operator to concatenate in SQL Server is '+', but this operator is also used to add values. Being the same operator for both, the…

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

MySQL, like most database managers, can easily modify the parameters that control memory sizes engaged in certain tasks, resource…

In a Data Warehouse there are a number of common dimensions such as Geographic and Time. I leave here a script to create the Time…

Data warehouse security is vital for organizations that take the huge step of collating all their important data in one place. Unauthorized…

Have you ever wondered how to disable the autocommit option in Sql Server Management Studio? The answer is quick. Simply uncheck the option…

We could need to access to MySQL from SQL Server. An easy way to do it is creating a linked server that uses an ODBC connection..

When organizations look to migrate from Oracle to PostgreSQL database, they usually see the advanced features, high performance, flexible…