How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15413 Views
- I also Faced
- E-Mail Answers
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 is trigger in salesforce?
Who developed sql server?
What can be used instead of trigger?
What is temporary table in sql server? Why we use temp table?
Define the one-to-one relationship while designing tables.
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to identify current user in ssrs report?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is meant by dirty read?
when you create a database how is it stored? : Sql server database administration
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Explain how to maintain a fill factor in existing indexes?
What are subqueries in sql server? Explain its properties.
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is snapshot parameter in ssrs?
