How to swap the data of two columns in a table. both the
columns containing varchar values.
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
How to create a trigger for insert only?
How to make a remote connection in a database?
what is the main function of a query parameter?
How many levels of sp nesting are possible?
What do you mean by an execution plan? Why is it used?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Why I am getting this error when dropping a database in ms sql server?
How to delete a login name in ms sql server?
What happens to a statement batch if there is a compilation error?
What are the differences between union, intersect, and minus operators?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is the difference between implicit and explicit transaction?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Explain try...catch with sql server?
What is difference between index seek vs. Index scan?