Home > DeveloperSection > Category

Latest blog on category "Database"

Databases To Learn In 2017

PostgreSQL releases its two versions 9.5 and 9.6, this year. They launched the UPSERT functionality after a long time that we know from MySQL (aka ON DUPLICATE KEY UPDATE), better full text search and speed improvements thanks to parallel queries, more efficient aggregation, replication, sorting and indexing.

By Ailsa Singh posted   26 days ago

Cursor in Sql server database

The Cursor is database object use for getting data and manipulating particular row at a time. It is associated with select query it processes each row returned by select query.

By Simond Gear posted   4 months ago

Difference between Delete, Truncate, Drop

Delete command is used to delete all the rows from the table. If we use where clause then according to condition specific rows will be deleted.

By Manish Sahu posted   5 months ago

Primary key and foreign key

Primary key is a key that uniquely identifies a record in a table. It cannot accepts a null value. We cannot have multiple primary key in a table.

By Samuel Fernandes posted   5 months ago

Uses of Stored Procedure in Database

It is a set of structured query language statement with given name. It is stored in the database in the compiled form.It is store in the compile form that’s why it can be shared by many program.

By Elena Glibart posted   5 months ago

Union and Union all Operator in sql

Union and Union all both are use for combine the result-set of two of more select queries.

By Manish Sahu posted   5 months ago

Where Clause in SQL Statement

Where clause is very important clause for filtering data .It search the records from the table according to the condition given in the where clause.

By Manish Sahu posted   5 months ago

Temporary Tables Magic Table and Injection in SQL

Tempopary tables are created at runtimes and ability to perform all the operation like the normal table. These tables have limited scope. This table is stored in tempdb.

By Allen Scott posted   8 months ago

User Define function in Sql Server

User Defined Functions play a major role in SQL. User Defined functions can be used to perform a complicated logic, can accept parameters and return data. Many a times we have to write complex logic which cannot be written using a single query. In such case, UDFs role is important. For example, we can call user defined function in a where clause or use a user defined function in a JOIN.

By Elena Glibart posted   11 months ago

Create database mail profile in sql server step by step.

In this article I would discuss about the Database Mail which is used to send the Email using SQL Server.


Create sql server agent job to run stored procedure

This Article describes how to create a Microsoft SQL Server Agent job step that executes Store procedure in SQL Server by using SQL Server Management Studio.


SQL View

In this blog describe the concept of sql view in sql server. SQL view is a virtual table. Here we give simple example of view.


CURSOR in SQL Server

In this blog describe the concept of cursor in sql server and how to create cursor in sql server, types of cursor. Here, I’m trying to demonstrate the good examples of cursors.


Creating, Inserting, Updating and Deleting in SQLite

In this blog, I’m explaining how to create and use the sqlite database in our application.


Locks in SQL Server

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


Checkpoint in SQL Server

In this blog, I’m explaining the checkpoint in sql server.


Views in SQL Server

In this blog, I’m trying to explain the views in sql server and how to create it.


User Defined Function in SQL Server

In this blog, I’m explaining user defined functions in sql server.


Transaction in SQL Server

In this blog, I’m trying to explain the transaction in sql server.


Rules in SQL Server

In this blog, I’m explaining the rules in sql server and how to create it.


Default Constraint in SQL Server

In this blog, I’m explaining the default constraint in sql server and how to create it.


Stored Procedure in SQL Server

In this blog, I’m trying to explain the stored procedure in sql server.


Keys in SQL

In this blog, I’m explaining the keys in sql and how to create it.


Create Table Statement in SQL

In this blog, I’m trying to explain the create table statement in sql.


Difference between GRANT and WITH GRANT in SQL Server 2008 R2

This blog provides an overview of the difference between GRANT and WITH GRANT using SQL Server 2008 R2.

By Vijay Shukla posted   4 years ago

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

Follow MindStick