Latest article tagged on "MSSQL Server"

In this blog we are explaining about how to create trigger for DML, DDL and logon server.

In this article, I’m explaining how to setup database mail in sql server.

Pivot is one the new relational operator introduced in SQL Server 2005. It provides easy mechanisms in SQL Server to transform rows into columns.

In this article I am going to explain a use of union operator in SQL Server Database with a real life scenario and example.

In this article I am going to demonstrate how to configure one-to-may and many-to-many relationship using Entity Framework code first approach, by taking a rich example in asp.net MVC.