PostgreSQL – Python Interface
Installation The PostgreSQL can be integrated with Python using psycopg2 module. sycopg2 is a PostgreSQL database adapter for the Python programming language. psycopg2 was written with the aim of being…
T-SQL – Functions
MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions − SQL Server COUNT Function −…
T-SQL – Indexes
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a…
PostgreSQL – Perl Interface
Installation The PostgreSQL can be integrated with Perl using Perl DBI module, which is a database access module for the Perl programming language. It defines a set of methods, variables…
T-SQL – Transactions
A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a…
PostgreSQL – PHP Interface
Installation The PostgreSQL extension is enabled by default in the latest releases of PHP 5.3.x. It is possible to disable it by using --without-pgsql at compile time. Still you can use yum…
T-SQL – Stored Procedures
The MS SQL Server Stored procedure is used to save time to write code again and again by storing the same in the database and also get the required output by passing…
PostgreSQL – JAVA Interface
Installation Before we start using PostgreSQL in our Java programs, we need to make sure that we have PostgreSQL JDBC and Java set up on the machine. You can check…
T-SQL – Sub-Queries
A sub-query or Inner query or Nested query is a query within another SQL Server query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main…
PostgreSQL – C/C++ Interface
This tutorial is going to use libpqxx library, which is the official C++ client API for PostgreSQL. The source code for libpqxx is available under the BSD license, so you are free…
- Go to the previous page
- 1
- …
- 544
- 545
- 546
- 547
- 548
- 549
- 550
- …
- 739
- Go to the next page