Interested to Buy Any Domain ? << Click Here >> for more details...
How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 17516 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep rana
create table tmp_t
(
aa varchar2(50),
bb varchar2(50)
)
--insert into tmp_t values('1','5')
select * from tmp_t
update tmp_t set aa=bb , bb=aa
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
Can the query output be sorted by multiple columns in ms sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Difference between drill down and drill through report.
What is difference between foreign key and unique key?
Explain identity in sql server?
How to get a list of columns in a view using the "sp_help" stored procedure?
State the difference between local and global temporary tables?
How to write an inner join with the where clause in ms sql server?
What are synonyms?
your distribution database is full what will u do
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How you provide security to cube? : sql server analysis services, ssas
How to remove duplicate rows from table except one?
Do you know what are various aggregate functions that are available?
How do I run sql server 2014?
