How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15937 Views
- I also Faced
- E-Mail Answers
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
Can an entity have two primary keys?
What is function of ROLLUP ?
Why people hate cursor?
Tell me what do we need queues in sql service broker?
Why we use functions in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
How to enter comments in transact-sql statements?
Explain difference between cross join and full outer join?
Explain a differential backup?
can an order by clause be used in a creation of a view?
how many no of arguments can be passed in procedures and functions
What is an etl file?
How optimize sql query with multiple joins in sql server?
Why use triggers?
What is database replication?
