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
Explain atomicity?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to throw custom exception in Stored Procedure?
What is an index. What are the types?
Define outer join in sql server joins?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Difference between report and query parameter.
How can we check the sql server version?
What is database replication?
What is data file in computer?
Why functions are used in sql server?
What are the differences between char and nchar in ms sql server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How to turn off warning messages during php execution?
How to search for a string in all stored procedure in sql server?