Tag Archives: CodeProject

Interview question – Is Clustered index on column with duplicate values possible?

By | August 13, 2015

Clustered index on column with duplicate values Through this article, we are going to discuss three important interview questions of SQL which are given below:-   1) Can we create clustered index on a column containing duplicate values?  2) Can we create a Primary Key on a table on which a clustered index is already defined? 3) If a… Read More »

Case Statement/ Expression in SQL Server

By | November 25, 2013

Case Statement/ Expression in SQL server    Sometimes we need to get one result output from multiple possible outcomes based on the evaluation of some expression. This expression can be a simple case expression which compares an expression with a set of Expression/Values to determine the result or it can be a search case expression… Read More »

SQL Triggers – An Introduction

By | November 10, 2011

Introduction Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are bound to specific tables. As per MSDN, triggers can be defined as the special kind of stored procedures. Before describing the types of triggers,… Read More »