This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies.
Database
Check Constraint in Sql Server
Check constraint is employed to restrict the range of values within a column.
Foreign Key Constraint in Sql Server
A FOREIGN KEY consists of one or more fields in a table that references the PRIM...
Unique Key Constraint in Sql Server
The UNIQUE constraint guarantees that no duplicate values can be entered into a ...
How Primary key constraint work in Sql Server
The guidelines for data in the table are stated using constraints. Applied for ...
How Constraints works in Sql Server
Constraints are the established rules and limitations imposed on tables or colum...
An Introduction to SQL Triggers and Their Use
The term "trigger" refers to a set of named SQL statements kept in Memory by the...
Columnstore index in SQL Server 2014
The column store index was created to improve query speed for applications with ...
Stored procedure parameters in Sql Server
The stored procedure/function returns the output parameter to the caller block.
How extended stored procedure works in SQL Server
A dynamic-link library (DLL) containing functions that may be invoked from withi...
Is it possible to invoke a stored method recursively?
Recursion is when a function or process calls itself directly or indirectly. Thi...