How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15940 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 self contained sub query?
What is the new security features added in sql server 2014? : sql server security
How to add a new dsn with the odbc driver for sql server?
what is sql server? : Sql server database administration
How to install sql server 2005 express edition?
What is the use of =,==,=== operators?
Do you know exporting and importing utility?
Can I delete event logs?
explain databases and sql server databases architecture? : Sql server database administration
What is data source document?
Can a synonym name of a table be used instead of a table name in a select statement?
What are the differences between user defined functions and stored procedures?
Tell me what is de-normalization and what are some of the examples of it?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is difference statement and preparedstatement?
