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 …
قراءة المزيد
Social Plugin