How to swap the data of two columns in a table. both the
columns containing varchar values.
Answer Posted / nilesh
UPdate temp
set col1=col2,
col2=col1
| Is This Answer Correct ? | 21 Yes | 15 No |
Post New Answer View All Answers
How to assign null values to variables or columns?
How to bind a view to the schema of the underlying tables?
What is normalization of database?
Explain about integration services of Microsoft SQL server?
What is dknf in normalization form?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How to insert new line characters into strings?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What are the difference between clustered and a non-clustered index?
What command do we use to rename a database?
What is the tcp/ip port on which sql server runs?
Can we shrink data file in sql server?
What are the new features of sql server 2012 reporting service?
Difference between Inner vs outer joins?
What do you understand by the data quality services in sql server?