How to use instead of triggers in SQL Server 2012

Hello and welcome, today let us discuss about how to use instead of triggers in SQL Server 2012. The main advantage of Instead of trigger are they support INSERT,UPDATE and DELETE the referenced tables which […]

Configure and Send Database Email in SQL Server 2012 Express Edition

Configure and Send Database Email in SQL Server 2012 Express Edition Hello and welcome, lets discuss how to¬†Configure and Send Database Email in SQL Server 2012 Express Edition. One of the main difference in SQL […]

Sequence in SQL Server 2012 : Complete guide with example

Sequence in SQL Server 2012 : Complete guide with example What is Sequence in SQL Server 2012 ? Well, lets keep it simple so that we understand it easily. Sequence is a user defined, schema […]