How to swap the data of two columns in a table. both the
columns containing varchar values.
Answer Posted / dinesh
select menu from (select m_name as menu from m_master) a
union select m_name as menu from db2 .dbo.m_master
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to defragment table indexes?
How to call stored procedure using http soap?
How do I open port 1433?
What is implicit cursors?
What does the update command do?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are the tables in sql?
What is the correct order of the logical query processing phases?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is user-defined inline table-valued function?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Tell me in brief how sql server enhances scalability of the database system?
How to change the password of a login name in ms sql server?
Can we join two tables without primary key?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?