How to swap the data of two columns in a table. both the
columns containing varchar values.

Answer Posted / amit kumar

select Col1,col2 into newtable

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to make a remote connection in a database?

725


How to backup SQL Server Reporting Services ?

122


What are recommended options to be used while using db mirroring? : sql server database administration

787


What is a deadlock and what is a live lock?

766


What are the advantages of using cte?

764


What is the default value of an integer data type in sql server 2005?

764


What were the latest updates to SQL Azure service?

104


what is a check constraint?

855


how many bits ip address consist of? : Sql server database administration

654


Explain how many types of relationship?

772


How connect excel to sql server?

702


what is spatial nonclustered index

735


What are approximate numeric data types in ms sql server?

775


How to fine-tune reports?

215


how many triggers you can have on a table? : Sql server database administration

725