SQL Script for Country Table with Data
Sometimes we need a table containing a list of all the countries. This article provides a SQL script containing county code, county name and its nationalities. Summary of the article: …
Category: SQL
Bulk Data Insertion from CSV to SQL Server
Bulk Insertion is a process to insert massive data into database. There are several ways to insert bulk data from CSV files into database. This article explains how to insert …
Difference between Join and Union
In relational database, the basic functionality of Join and Union is to combined two ore more tables. Everyone follow their own mechanism. This article describes a comparison between Join and …
SQL CASE Statement or Expression
SQL CASE statement or SQL CASE expression is a way to perform a particular task based on some conditions. This article describes how to use CASE expression in SQL. Summary …
What is Database Constraint?
This article describes about the database constraint in SQL. Summary of the article: What is Database Constraint? Types of Database constraints How to make a Great Primary Key? Primary Key …
Transactions in SQL Server
This article explains SQL transactions, how to use transaction in SQL? Summary of the article: What is SQL Transactions? Properties of SQL Transactions Transaction Control Example of SQL Transactions What …
SQL Queries Optimization Tips
Every time we writes lot of SQL queries. But most of the time we don’t consider its efficiency. Query optimization is the vital process for any database related applications. Its …
How to use while loop in SQL statement?
This article describes about SQL While Loop and how to use it? Summary of the article: What is While Loop? Example of WHILE Loop in SQL Example of WHILE Loop …
What are the Advantages and disadvantages of Stored Procedure (SP)?
This article describes about the advantages and disadvantages of Stored Procedure (SP). Summary of the article: Advantages of SP Disadvantages of SP It is faster It is Pre-compiled It reduce …
SQL Join
In a relational database, SQL join is a very important feature. SQL Joins are used to get data from other tables. It is a part of SQL query that retrieves …
What is SQL Injection?
This article describes about the basic overview of SQL Injections and how to protect it?. Summary of the article: SQL Injection How to Prevent SQL Injection? SQL InjectionSQL Injection is …
What are the SQL statements?
This article describes about SQL statements. Summary of the article: What are the SQL statements? Data Definition Language (DDL) Statements Data Manipulation Language (DML) Statements Data Control Language (DCL) Statements …
Difference Between DDL and DML
This article describes about the basic overview of DDL and DML and their difference . Summary of the article: Data Definition Language (DDL) Examples of DDL Data Manipulation Language (DML) …
Database Trigger
In database, trigger is a set of SQL statements or queries that automatically fires actions when a specific operation occurs. It is used to ensure the coordinated performance of related …
Stored Procedure
Stored Procedure is an attractive feature of a relational database that contains some SQL statements and perform predefine task based on creator demand. Most the relational database support stored procedure, …
SQL BETWEEN operator for datetime
This article describes about the SQL between operator, how to use SQL between operator in date time operation? Create a Temp table. For the sql query is Create Table #Temp …
Remove or trim the leading zeros in SQL
Some times we need to remove or trim the leading zeros in an alphanumeric column of a table flied. Following SQL query will help us to do this. DECLARE @String …
Difference between temp table and table variable
In SQL, temp tables and table variables are used to save or store data in temporary basis. Both are almost same, but have some difference. This article describes a comparison …
SQL Server Database Backup
Backup is an vital part for any database system. It reduce accidental data loses. This article describes how to create a database backup in SQL query. Summary of the article: …