How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 14817 Views
- I also Faced
- E-Mail Answers
Answer Posted / m s aptil
update tab1 set name=name1,name1=name
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
When does a workload on SQL Azure get throttled?
How to override dml statements with triggers?
How to generate create view script on an existing view?
What is the difference between functions and scalar functions?
Can we join two tables without primary key?
How do you delete a data source?
How you provide security to cube? : sql server analysis services, ssas
What are alternate keys?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is query processing?
What are the five characteristics of good data?
How to drop existing views from a database in ms sql server?
Is it safe to delete log files?
What are the advantages of using stored procedures?
