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

How you trouble shoot when any job fails

0 Answers  

Explain the commands in sql server?

0 Answers  

What is difference between primary key and foreign key?

0 Answers  

How to set a database state to offline in ms sql server?

0 Answers  

How data can be copied from one table to another table?

0 Answers  

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

What is a document index?

0 Answers  

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

What are the aggregate and scalar functions?

0 Answers  

What are the five characteristics of good data?

0 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,