Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: SQL SERVER DBA

    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...

  • RE: Like operator in Case statement

    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...

  • RE: Delete record without using Delete keyword

    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...

  • RE: Delete record without using Delete keyword

    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...

  • RE: SQL server Interview Question

    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...

  • RE: SQL server Interview Question

    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...

  • RE: remove duplicate records from a table

    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...

  • RE: remove duplicate records from a table

    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...

  • RE: remove duplicate records from a table

    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...

Viewing 9 posts - 1 through 9 (of 9 total)