How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15970 Views
- I also Faced
- E-Mail Answers
Answer Posted / mysql
sorry guys, all ur answers are not working properly.
Try to answer in one sql statement.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
what are the types of indexes? : Sql server database administration
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What do you understand by sql server agent?
How to use union to merge outputs from two queries together in ms sql server?
What is lock escalation? : sql server database administration
What is row_number function?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Explain the properties of subqueries in sql server?
What do you understand by recursive stored procedures?
Can binary strings be used in arithmetical operations?
How can I know what locks are running on which resource?
Which are the two editions in which SQL Azure database available?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Why use “nolock” in sql server?
