October 29, 2020

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 …

Read More

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 …

Read More

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, …

Read More

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 …

Read More

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. …

Read More

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

Read More

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 …

Read More

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 …

Read More

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 …

Read More

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: …

Read More

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 …

Read More

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 …

Read More

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 …

Read More

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 …

Read More

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 …

Read More