Problem ::
Interchange 0 by 1 and 1 by 0 in given table ?
A most of time a interviewer asked this quetion,check below table.
Table Script with data ::
create table #temp (no_s int)
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
select * from #temp
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
insert into #temp (no_s)values('0') insert into #temp (no_s)values('1')
select * from #temp
Data ::
No comments:
Post a Comment
if you have any doubt any suggestions do comment