SQL constraints are used to specify rules for the data in a table. Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. Using constraints is preferred to using DML Triggers, rules, … More SQL SERVER 2017 TUTORIAL : Constraints

This tutorial may help you understand relationship between tables in sql server.Types of relation. how to create and utilize relationship.This topic describes how to create foreign key relationships in SQL Server 2017 by using SQL Server Management Studio or Transact-SQL. You create a relationship between two tables when you want to associate rows of one … More SQL SERVER 2017 TUTORIAL : PART 07 (RELATION)

Function is a database object in  Microsoft Sql Server. Basically it is a set of sql statements that accepts only input parameters, perform actions and return the result. Function can return only single value or a table.in SQL SERVER 2017 TUTORIAL : PART 06  you can learn it

This video demonstrates the steps to create a stored procedure that accepts a parameter.A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system as a group, so it can be reused and shared by multiple programs. There are so may … More SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)

This video will provide you general idea about sql server view creation.A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data. Unless indexed, a view does not exist as a stored set of data values in … More SQL SERVER 2017 TUTORIAL: PART 04 (VIEW)