# Yearly Archives: 2013

## Happy New Year 2014

By | December 31, 2013

HAPPY NEW YEAR 2014 Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my blog last year 2013. I hope this support will continue this year too. May God bless all… Read More »

## Deleting Duplicate rows using CTE

By | December 29, 2013

Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example I will tries to show how to delete the duplicate rows using CTE. Suppose we have a table name “tbl_dublicatedata”… Read More »

## Answer -Question of the Week – 25/12/2013- Question 1

By | December 28, 2013

Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid  Studentname 1               Vivek Johari 2               Chandra Singh 4          … Read More »

## Question of the Week – 28/12/2013 – Question 2

By | December 28, 2013

Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows contains “Vivek Johari” and the next 5 rows contains “Abhinav Golwalkar” tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari Vivek Johari Vivek Johari Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Now… Read More »

## Question of the Week -25/12/2013- Question1

By | December 25, 2013

Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid   Studentname  1               Vivek Johari 2              Chandra Singh 4            … Read More »

## Ranking Functions in SQL Server

By | December 25, 2013

Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition. For example, suppose we want to give rank to sales man according to their sales amount in a particular month/year. For this purpose, SQL server provides us Ranking functions. Ranking functions are used to provide… Read More »

## Stuff VS Replace function in SQL Server

By | November 25, 2013

Stuff function: – This function is used to replace string from the given start position, passed as 2nd argument with string passed as last argument. In Stuff function, 3rd argument defines the number of characters which are going to be replaced.   Syntax:- STUFF ( character_expression , start , length , replaceWith_expression ) For example:-… 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 »