Latest article tagged on "SQL"

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 this article we are going to how to copy an existing table to new table in SQL Server with an example.

In this article we are going to explain what is subquery in SQL or how to create subquery in SQL or how to use subquery in SQL server with example.

In this article we are going to explain what is Cursor in sql or how to create Cursor in sql or how to use Cursor in sql server with example.

In this article we are going to explain what is Multi-statement Table-Valued User-Defined Function in sql or how to create Multi-statement Table-Valued User-Defined Function in sql or how to use Multi-statement Table-Valued User-Defined Function in sql server with example.

Here we are going to explain what is Table-valued functions in sql or how to create Table-valued functions in sql or how to use Table-valued functions in sql server with an example.

Here we are going to explain what is scalar function in sql or how to create scalar function in sql or how to use scalar function in sql server with example.

Either you are an experienced professional or early in IT career, starting as a SQL server developer is always a challenging task.

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.

In this blog we are explaining about how to create trigger for DML, DDL and logon server.

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’m explaining how to setup database mail in sql server.