Viewing 9 posts - 1 through 9 (of 9 total)
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...
January 10, 2011 at 1:43 am
Dave Ballantyne (11/25/2010)
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...
November 25, 2010 at 4:41 am
LutzM (10/16/2010)
jaffrey (10/16/2010)
Before going any further I'd like to know the true reason why you don't use the simple DELETE statement. Also, please describe the business case you're working on.
I...
October 17, 2010 at 4:09 am
Of course, there will be slightly more effort if foreign keys, constraints, triggers and the like will be involved....
So far the query works fine as long as the constraints,triggers,procedures are...
October 16, 2010 at 7:47 am
GilaMonster (10/15/2010)
October 16, 2010 at 1:13 am
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...
October 16, 2010 at 1:09 am
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...
October 15, 2010 at 8:57 am
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...
October 15, 2010 at 8:35 am
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...
October 15, 2010 at 6:41 am
Viewing 9 posts - 1 through 9 (of 9 total)