category

home / developersection / category

SQL Server 2017 CTP 2.0 Now Available
mssql server 17-May-2017
SQL Server 2017 CTP 2.0 Now Available

The next version of formerly known SQL Server, RDBMS is out now as SQL Server 2017 Community Technology Preview 2.0.

Use of DML, DLL and logon trigger in SQL
mssql server 05-Oct-2016
Use of DML, DLL and logon trigger in SQL

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

Database Mail in SQL Server
mssql server 28-Nov-2014
Database Mail in SQL Server

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

Pivot with Dynamic columns in SQL Server
mssql server 08-Oct-2014
Pivot with Dynamic columns 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.

Union Example in SQL Server
mssql server 08-Oct-2014
Union Example in SQL Server

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