Monthly Archives: August 2014

Intersection command in SQL Server

Posted on August 11, 2014 by vivekjohari

This function is used to returns distinct values that are returned by both the query on the left and right sides of the INTERSECT operand. For intersection command, below basic rules must be followed. The number and the order of … Continue reading →

Posted in SQL Basic Concepts, SQL Server | Tagged | 31 Comments

Exception handling in SQL Server

Posted on August 11, 2014 by vivekjohari

SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write the SQL Statements within the Try block and if any exception occurred control automatically goes to the group of SQL … Continue reading →

Posted in Most Imp SQL Concepts, SQL Server, SQL Server Exception handling | Tagged | 31 Comments