September 30, 2020

Index Optimization Tips

This article describes how to optimization indexes in table? Summary of the article: What is Index Optimization? Index Optimization Tips What is Index Optimization? Index Optimization is the process to …

Read More

How to use Paging in SQL Queries?

Paging is one of the most important tasks when developers developed applications. This article describes how to use paging in SQL queries or How to select 5-10 records?. In SQL …

Read More

How to make a Great Primary Key?

The primary key is in important factor for any relational database. It plays a vital role. It has numerous functionalities. On a table we can create a primary key in …

Read More

SQL or Structured Query Language

This article describes introduction to SQL, basic overview of SQL. Summary of the article: What is SQL? Why we should Use SQL? SQL Statements SQL Commands SQL Functions What is …

Read More

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

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