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 update muliple row in single query?
What are the 2 types of classifications of constraints in the sql server?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is the maximum size of sql server database?
Do you know what are different types of replication in sql server?
Explain about system database?
What is user-defined inline table-valued function?
What is wrong with sql server client libarary dll, ntwdblib.dll?
Can we call future method from trigger?
Explain the stored procedure?
What is an identity column in insert statements?
Does sql server use java?
What is a database table?
Mention a few common trace flags used with sql server?
How do you start single user mode in clustered installations?