Update One Table with Another Table
Sometimes we need to update the data of one table with the data from another table in SQL. It can be done in different ways. We can use stored procedure, …
Category: Database
Error Handling or Exception Handling in SQL Server
Error handling or exception handling is the most vital part of any software development. Generally we are not interested to show any type of application error to end user. Error …
Data Types in SQL Server
The data type is an attribute that defines the type of data that the object can hold. During table creation we have to decide what types of data will be …
SQL Views
In SQL, a View is a virtual table that is generated based on a SQL statement. It has no own data, but it returns data from others table. This article …
Random Number in SQL
In programming random number is very popular and it is frequently used for different purpose. We can creates random number in different ways: we can use programming language, SQL queries, …
What are the Difference between SQL Server Replication and Mirroring?
SQL server replication and database mirroring is used copy data into different server or location. Anybody can confused with them. Both have some difference. This article describes some difference between …
Oracle Database
Oracle is a database management application or software. At present It is the leading RDBMS vendor worldwide. Currently nearly half of RDBMS worldwide market is owned by Oracle.This article is …
Database Cursor
A cursor is a database object that enables traversal over the records in a database on a row by row basis. This article describes the basic overview of SQL cursor. …
Best Top Computer Programming Forum | Blog | Community
This article describes about best top Computer Programming Forums, Blogs , Community. The list is given bellow: www.cybarlab.com www.codeproject.com www.stackoverflow.com www.codeguru.com www.devshed.com www.forums.asp.net www.social.msdn.microsoft.com/Forums www.social.msdn.microsoft.com/Forums/en/category/sqlserver www.oracle.com www.mysql.com
Cumulative Sum in SQL
For reporting purpose, some time we need to calculate the cumulative sum of a particular column or show running total of a numeric column of a table. It can be …
Difference between Delete and Truncate
Both Delete and Truncate is SQL command used to delete records from the table. Their functionalities are almost same, but have some difference which can arise confusion. This article describes …
What is Normalization?
This article describes about normalization. Summary of the article: What is Normalization? Types of Normalization First Normal Form Second Normal Form Third Normal Form Advantages of Normalization Disadvantages of Normalization …
How to Prevent SQL Injection?
SQL Injection is one of the web attack mechanisms used by hackers to access the database. This article describes SQL Injection and how to prevent it. Summary of the article: …
Difference between WHERE and HAVING Clause
WHERE and HAVING are SQL clauses used for searching purposes. Both are almost same, but have some difference that may arise confusion. This article describes what is the difference between …
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: …
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 …
Data Model or Database Model
The database model is the internal structure of a database system. This describes the internal functionality of the database. Every database system follow at list one data model. This article …
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 …