as a developer you should have a good understanding of SQL server and TSQL, which is a bonus.

Moving to DBA, you should sit with an experienced DBA and work with...

Dave Ballantyne (11/25/2010)

---

Try this...

SELECT empid,contact,'CITY'=

CASE

WHEN contact like '9%' THEN 'Chennai'

WHEN contact like '8%' THEN 'Bangalore'

WHEN contact like '7%' THEN 'Mumbai'

WHEN contact like '6%' THEN 'Pune'

ELSE 'Oversease'

END

FROM emp;

BTW , LEFT...

LutzM (10/16/2010)

---

jaffrey (10/16/2010)

---

I...

So far the query works fine as long as the constraints,triggers,procedures are...

GilaMonster (10/15/2010)

---

A list of questions is not going to get you through an interview. A competent interviewer can tell the difference between someone who has memorised answers and who knows...

It is not about memorize the list of interview questions, Just i want to get some ideas from it.Its like what are the concepts to be asked in the interview.I...

sorry since i am new to sql server i dont understand, so please tell me the exact query to execute for the 1st one..I tried but it wont work ,i...

hai john,

Thanks in advance

As i gone through your reply

I dont know how to implement the 1st of ur option in my table,You said Create a new...

This is the sample table and insert statements:

create table dup(id int name varchar(50))

insert into dup values (1 'raja')

insert into dup values (1 'raja')

insert into dup values (2 'krishna')

insert into dup...