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

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.

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.

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.

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

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

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.

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. Let us explain both individuallyUnion-Union Operator is us

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.

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.