Latest blog on category "Database"

WHAT ARE TRIGGERS?

A trigger is a set of SQL statements stored in the database structure. A Trigger is a database object that is attached with the table in SQL.A SQL trigger is fired whenever an event or function associated with a table occurs .......

 765 View(s)

What is Normalization In Database?

The structuring of Database is normalization, Normalization is the process of restructuring tables to eliminate design problems. This process removes redundant data, makes it possible to access data more easily....

 933 View(s)

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....

 977 View(s)

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....

 1038 View(s)

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....

 1120 View(s)

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....

 2536 View(s)

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....

 4795 View(s)