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
What are the differences between union, intersect, and minus operators?
How can I know what locks are running on which resource?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
why would you use sql agent? : Sql server database administration
What are the advantages of policy management?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
How do I run sql server 2014?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Why I have to use stored procedures?
what stored procedure would you use to view lock information? : Sql server administration
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is difference between createstatement and preparedstatement?
What does <> symbol mean?
How to create an index on a view?
Can we write ddl in trigger?