FIRST Normal Form Every value in a cell of an Attribute should be an ATOMIC, which means that an attribute cell can con…

SUPER KEY Super Key is an Attribute or a Set of Attributes that can uniquely define a row in a t…

VIEWS in SQL Server A View is a method of Encapsulating a Complex query into a simple form, For example, your Cl…

FUNCTIONS in SQL Server A function is a set of codes that returns a value, the value can be Scalar or in…

What are CTE & why should we use them ? CTE or Common Table Expressions are very similar to Views or D…

List of System-Defined Error Messages We can use sys. messages Table to look for the specific errors with their …

LOST UPDATE A lost Update happens when one transaction updates a record and the same record is accidentally updated by …