Replication in SQL Server is a set of technologies for copying and distributing data and database objects from one database to another database by synchronizing between databases by maintain consistency.

Most Refered SQL Terms


Its a process of organazing the colums (attributes) and tables of database to reduce any redundancy and improve data integrity.A relational database is considered in "normalized" if it meets third normal form.

Stored procedure

A stored procedure is a set of SQL statements that has been created and stored in database.

Ex: create procedure dbo.sp_name
select * from


In SQl Server it creates a user-defined function on SQL Server and also Azure SQL Database.

Ex: Create function myfunction
@FirstName nvarchar(50),
@LastName nvarchar(50)
returns varchar(100)
Begin return (Select @FirstName + ' ' + @LastName);

Sub Queries in SQL

A subquery is a query with in another query and embedded within a where clause.

Ex:Select column_name[,column_name] from table1 [,table2] where column_name operator (select column_name [,column_name] from table1[,table2] [where])