Home > DeveloperSection > Category

Latest article on category "Database"

SQL Joins

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

 Database Join  SQL 
By Anupam Mishra posted   9 months ago

SQL KEYS IN RDBMS

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

By Anupam Mishra posted   10 months ago

Working With BLOB(Binary Large Objects)

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.

By Anupam Mishra posted   one year ago

Working with SQLite database

Hi everyone in this article I’m explaining about how to download SQLite Database and working with SQLite database.

By Kamlakar Singh posted   one year ago

Passing table as a parameter to stored procedure

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

By Sanjay Singh posted   2 years ago

Transaction in SQL Server

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

By Dev Patel posted   3 years ago

JOIN in SQL

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

By Dev Patel posted   3 years ago

Cursor in SQL

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

By Dev Patel posted   3 years ago

Trigger in SQL Server

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


Joins in SQL Server

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


Cursor in SQL Server

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


Restart Computer Failed Error in SQL Server 2008

Restart Computer Failed Error in SQL Server 2008


SQL Command

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

By Deepali Dutta posted   3 years ago

Design Query in Editor SQL Server 2008 R2

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

By Vijay Shukla posted   3 years ago

Create a user define function using SQL Server 2008 R2

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

By Vijay Shukla posted   3 years ago

Copy data from one table to another table in 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.

By Vijay Shukla posted   3 years ago

DELETE, TRUNCATE with RESEED Identity in SQL Server

DELETE, TRUNCATE with RESEED Identity in SQL Server


How to Drop Primary Key Constraint

How to Drop Primary Key Constraint


SQL SERVER – Maximum Number of Index per Table

SQL SERVER – Maximum Number of Index per Table


Date and Time Function in SQL

Date and Time Function in SQL


Select Command in SQL Server

Select Command in SQL Server


Nested Queries in SQL Server

Nested Queries in SQL Server


Change Data Capture (CDC) in SQL Server

Change Data Capture (CDC) in SQL Server


How to Backup a Table in SQL Server

How to Backup a Table in SQL Server


How to Backup a SQL Server Database

How to Backup a SQL Server Database


Don't want to miss updates? Please click the below button!

Follow MindStick