Database

Check Constraint in Sql Server

Check Constraint in Sql Server

Check constraint is employed to restrict the range of values within a column.

Foreign Key Constraint in Sql Server

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

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

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

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

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

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

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

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?

Is it possible to invoke a stored method recursively?

Recursion is when a function or process calls itself directly or indirectly. Thi...

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies.