Good question Sasidhar

+1

nitinkachhwaha (10/10/2013)

Please find the query to update the cty to 'A' where cty is 'B' and from cty 'B' to 'A'.

BEGIN TRAN

SELECT *FROM CITY

UPDATE CITY

SET CTY = CASE WHEN...

NO.

DELETE A FROM A INNER JOIN B ON A.consumerID = B.consumerID WHERE A.consumerID = 99 AND B.deleteflag = 1

CREATE TABLE [A]

(consumerID INT, XXXX INT, AAAAA INT, BBBB INT)

CREATE TABLE

(consumerID INT, Product INT, DeleteFlag BIT, DDDD INT)

INSERT INTO A VALUES (99,1,2,3)

INSERT INTO A VALUES (100,2,3,4)

INSERT INTO B VALUES...

good one

good one.

easy

Luis, Gail and Sean, Thanks for your comments on this post. Including OP, anyone else who is following this post, will add something to his Knowledge.

Luis, I disagree on not...

If ordinal position of column is used instead of column name, then a new programmer will always have to look into the table to find out which column is used...

You are right Dwain.

In such cases, we are mostly in a lose-lose situation. Either we will be rejected as we are not as idiot as we should be, or we...

I have faced the same situation in an interview where interviewer asked me a question on triggers.

I tried my hard to convince him that we have...

@dastagiri16,

I'm sure you was not applying for the job of DBA.

A table spool scans the input and puts a copy of each row returned in a hidden spool table, which is stored in the the tempdb database (as the query...