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

what is package and it uses and how can u call a package

1554


What is a data source file?

493


How do I find my localdb version?

486


what are triggers? : Sql server database administration

494


Where are stored procedures in sql server?

561






What is the osql utility?

534


what are different types of backups available in sql server? : Sql server database administration

493


What is open database communication (odbc)?

567


What is page-level compression?

549


What is trace flag in sql server?

517


How to turn on the mssql api module in php?

559


Tell me can we use custom code in ssrs?

588


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1427


what is spatial nonclustered index

536


How do I open port 1433?

517