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
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
what is denormalization? : Sql server database administration
How to define the name and server for a new dsn?
What is microsoft sql server?
What are the three different part of rdl file explain them?
How to invoke a trigger on demand?
What is replication with database mirroring? : sql server database administration
what is the difference between a primary key and a unique key? : Sql server database administration
How many types of subqueries are there in sql server?
Find columns used in stored procedure?
Does partitioning help performance?
What is pessimistic concurrency?
What is a view in sql?
Do you know what is blocking?
What are trace flags and mention a few common trace flags used with sql server?