How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15411 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
what's the information that can be stored inside a bit column? : Sql server database administration
What is the difference between a fill factor of 100 and 0?
How to rebuild the master database?
What does select 1 mean?
Can you index views?
What are various ways to enhance the ssrs report?
Can binary strings be used in arithmetical operations?
What is ms sql server triggers?
What is an indice?
Which are new data types introduced in sql server 2008?
How can we get count of the number of records in a table?
What are diverse clauses that form a part of sql?
How to optimize stored procedures in sql server?
Can we call stored procedure in view in sql server?
What is the difference between getdate and sysdatetime?
