create table san(empid int,empname varchar(10)) insert into san values(1&#

How to swap the data of two columns in a table. both the
columns containing varchar values.

Question Posted / san

Answer Posted / san

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

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain what is sql server english query?

1041

What is an expensive query?

922

What are the methods used to protect against sql injection attack?

1057

How to sort query output in descending order in ms sql server?

942

What is a hint?

987

can an order by clause be used in a creation of a view?

1170

What are rows and columns?

1017

What is the latest version of microsoft sql server?

1039

List out some of the requirements to set up a sql server failover cluster?

1024

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1020

What are the elements of dbms?

957

Explain a checkpoint?

1023

What is sql server schema compare? How we can compare two database schemas?

1023

What is relationship? What number of sorts of relationship are there?

1131

Explain subquery and state its properties?

1036