How to swap the data of two columns in a table. both the
columns containing varchar values.
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 |
Post New Answer View All Answers
What do you know about normalization and de- normalization?
Do you know how to implement service broker?
what is a self join? Explain it with an example? : Sql server database administration
Define right outer join?
What is the security principal at the server level that represents your session?
What is primary key, unique key, and foreign key?
What is a join in sql?
What is the xml datatype?
What are the 3 types of schema?
Do you know hot add cpu in sql server 2008?
What is the difference between Stored Procedures and triggers?
what is a deadlock? : Sql server database administration
What is a natural primary key?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How do I create a partition table in sql server?