Check records / rows exists in a table

Check records exists in a table. If the records are present in a table then do this opreations. If records are not present then do other operations. I have used a sample temp table variable to illustrate this.

SQL : Retrieve (Select) Commands

SQL SELECT may be the most commonly used command by SQL programmers. It is used to extract data from databases and to present data in a user-friendly table called the result set.

Select queries require two essential parts. The first part is the “WHAT”, which determines what we want SQL to go and fetch. The second part of any SELECT command is the “FROM WHERE”. It identifies

SQL : Create (Insert) Commands

The INSERT statement allows you to insert a  record(s)  into a table.

SQL Datatypes

See the  list of general SQL datatypes which are mostly common for all relational databases.

SQL

SQL stands for “Structured Query Language”.  This language is used to query to database and do operations like Create, Retrieve, Update and Delete (CRUD). Learn the basic of sql language which are mentioned here.

To make very simple and easy understanding and to learn fast i have grouped SQL into 4 major sections they are Create, Retrieve, Update and Delete (CRUD)