dastagiri16 (9/25/2013)
hi,one of the interviewer asked the question about updating...so i have added test table like below...
USE [Practice]
GO
/****** Object: Table [dbo].[mytable] Script Date: 09/25/2013 13:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mytable](
[city] [nchar](10) NULL
) ON [PRIMARY]
GO
and i have inserted values like
insert into mytable (city) values ('A')
so now i want to write update querty to update city value from A to B then B to A by using any query....
Not all questions asked by interviewers have a positive answer. Sometimes they ask the "wrong" thing to see what you'll say.
Also, not all interviewers actually have the knowledge to conduct a proper interview. They might actually but incorrectly believe that you can update the same row more than once in the same "query".
--Jeff Moden
Change is inevitable... Change for the better is not.