Answer / nilesh

UPdate temp
set col1=col2,
col2=col1

Answer / ami tkumar

Sorry for previous answer.

DECLARE @temp AS varchar(50)
UPDATE swapdata SET @temp=value2,value2=value1,value1=@temp

Answer / mysql

sorry guys, all ur answers are not working properly.
Try to answer in one sql statement.

Answer / dinesh

select menu from (select m_name as menu from m_master) a
union select m_name as menu from db2 .dbo.m_master

Answer / dinesh

select names from
(select full_name as names from table 1) a
union
select full_name as names from table 2

Answer / san

create table san(empid int,empname varchar(10))
insert into san values(1'san')
update san set empid=empname,empname=empid

Answer / sandeep rana

create table tmp_t
(
aa varchar2(50),
bb varchar2(50)
)


--insert into tmp_t values('1','5')


select * from tmp_t

update tmp_t set aa=bb , bb=aa

Answer / amit kumar

select Col1,col2 into newtable

Answer / m s aptil

update tab1 set name=name1,name1=name

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

What are the advantages of partitioning?

0 Answers  

What is the meaning of sql server?

0 Answers  

Which stored procedure will you be running to add a linked server?

1 Answers  

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

How to disable a login name in ms sql server?

0 Answers  

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

Can sql server be linked with other servers like oracle?

0 Answers  

How to find out the list schema name and table name for the database?

0 Answers  

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers