Replication in SQL server 2008

Replication utilizes a distributing industry wording, which incorporates Publisher, Distributor, Subscribers, productions, articles, and memberships. • Publisher produces distributions

How to tune SQL Server DBA

Tuning a Database is not a simple task, it is a complex task. Where the performance issues performed by tuning process which is Trust Effort. The SQL server Dashboard, according to the database consultant, should examine this.

SQLite- TRIGGERS EXAMPLE

In this article we will see the TRIGGER example that is automatically col on INSERT, DELETE, UPDATE operation, its main purpose is creating a log of any type of operation being on database.

iOS : Creating Sample App Using SQLite Database

In this article we will learn how to create iPhone app using SQLite Database as Back-End.

Use of JOIN clause in SQLite Database

The SQLite Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.

SQLite – where clause

In this article we are going see the SQLite WHERE clause that is used to specify a condition while fetching the data from one table or multiple tables.

SQLite - Expressions

SQL Expression is a combination of one or more values, operators and SQL functions that evaluate to a value.

SQLite Operators

Operators are used to build expressions. SQL operators are very similar to mathematical operators. SQLite supports unary and binary operators.

SQLite - SELECT Query

SQLite SELECT statement is used to fetch the data from a SQLite database table which returns data in the form of result table.

SQLite - Data Type

SQLite data type is an attribute that specifies type of data of any object. Each column, variable and expression has related data type in SQLite.