How to swap the data of two columns in a table. both the
columns containing varchar values.
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
Explain system views?
Write SQL queries on Self Join and Inner Join.
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How to modify existing triggers using "alter trigger"?
How to find which stored procedure is currently running in sql server?
How do you migrate data from mssql server to azure?
Do you know what is fill factor and pad index?
What is snapshot parameter in ssrs?
when would you go for denormalization? : Sql server database administration
How do you create a data source?
Can we install sql server 2016 on windows 7?
What is nested transaction?
What do you mean by SQL injection attack?
Explain the dbcc pintable command when would you use it?
What were the latest updates to SQL Azure service?