Compound Operators in SQL Server 2008

Compound assignment operator means an operator combined with another operator. We have used such assignment operators in C++ and C#. This Compound Assignment Operator is introduced in SQL Server 2008.. Read More…

MERGE Command

In SQL Server 2008, Microsoft introduces the MERGE functionality through the MERGE command. The MERGE command inserts rows that don’t exist and updates the rows that do exist. Read More…

Row Constructor in SQL-2008

One of the cool features of SQL 2008 is Row Constructor. The concept ‘Row Constructors in SQL Server 2008’ basically deals with the crux of multiple inserts performed at one shot. Instead of having to call multiple inserts, we could just insert multiple rows with a single TSQL Statement… Read More..

TIME DataType in SQL2008

Check out my article on “TIME DataType in SQL2008″.

SQL Server 2008 introduces a TIME data type which allows us to store the time without the date. Read More…