Standard Naming Conventions for SQL Database Design
Naming Conventions is an important factors for any type of database design. It’s benefits are high. It makes a simple database generic for others. This article describes what standard should …
Category: SQL
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 …
Cross Tab Queries using PIVOT in SQL
Some times we need to convert row to column in SQL. We can do that by using basic SQL query. But most of the time it may complex. For that …
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 …
SQL query to convert column to row
During the creation of table maximum time we only consider the purpose and efficiency of the table. All time we don’t think about the reporting. Some times we may need …
Difference Between Primary Key and Unique Key
In relational database system primary key and unique key are two important concepts. Both are used to uniquely identify a row in a table. Though both can identify a row …
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 …
Difference between Stored Procedure and Function
In a database system, stored procedures and functions are SQL statements that provide similar functionality. Both allow us to create bundles of SQL statements or codes that are stored on …
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 …
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, …
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, …
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 …