Latest article on category "Database"

Key plays an important role in SQL or Oracle database. Generally it is used for defining a unique set of records. It also establishes the connection (link) between more than one table.

MYSQL  SQL 

In Oracle alter is command or statement that is used to perform a different type of operation in any database. Alter command mainly use for add a column, delete a column, modify a column and also rename a table in any database.

Almost all businesses today are in the habit of using databases. Whether it is primarily for client data storage, sales information, or even for internal files, all advanced businesses would be running on data.

A view in a database is a "virtual" table. It is created using scripts and stored in a structural form, but they are not stored as a data in any part of the database. It can be part or whole of an existing table.

Join is use to combine more than two table to find result as per our need.Join is possible when there is one match in joining table.

A SQL join is combines records from two or more tables in a relational database by using values common to each.

Join  SQL 

In this article, I want to explain about SQL Keys such as PRIMARY KEY, FOREIGN KEY, COMPOSITE KEY, and UNIQUE KEY AND ALTERNATE KEY.

A BLOB is a build-in data type supported by the database implementing SQL 99 alias SQL3 Standards. A BLOB is used to store large binary data ,such as bit images,audios,and multimedia clips as the column value in a database table.

In this article, I’m going to explain how to pass a table as a parameter to stored procedure in sql server.

In this article I am trying to explain the concept of Transaction in SQL Server.

In this article I am trying explain the concept of JOINs using SQL Server.

In this article I am trying to explain the concept of Cursor in SQL Server.

In this article, I’m explaining the triggers in sql server and its types.

In this article, I’m trying to explain the concept of joins in SQL server and its types.

In this article, I’m trying to explain the concept of cursor in SQL server.

Restart Computer Failed Error in SQL Server 2008

These are some SQL Command which we can use in changing Table and Field according to requirement.

In this Article I am going to teach how to design queries in Design Query Editor.

In this article I am trying to explain how create a user define function using SQL Server 2008 R2.

In this article I am trying to explain how to copy data from one table to another and how to copy data as well as create table in SQL Server 2008 R2.

DELETE, TRUNCATE with RESEED Identity in SQL Server

How to Drop Primary Key Constraint

SQL SERVER – Maximum Number of Index per Table

Date and Time Function in SQL

Select Command in SQL Server