How to swap the data of two columns in a table. both the
columns containing varchar values.
Answer Posted / dinesh
select names from
(select full_name as names from table 1) a
union
select full_name as names from table 2
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the extra roles available in msdb? : sql server security
What is spatial and temporal data?
What is the difference between for xml raw and for xml auto?
what is raid? : Sql server database administration
How would you go about developing a ssrs report?
Which database stores information about replication?
Explain in brief how sql server enhances scalability of the database system?
What is difference between clustered and non clustered index?
How does index makes search faster?
What are temporal tables in sql server 2016?
What are the tables in sql?
What is the difference between functions and scalar functions?
Do you know how to store and query spatial data?
Explain different types of self contained sub query?
What is etl - extraction, transformation, and loading?