How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 15412 Views
- I also Faced
- E-Mail Answers
Answer Posted / amit kumar
select Col1,col2 into newtable
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How do you start single user mode in clustered installations?
What is the maximum size of a row in sql server?
How do I create a trace in sql server?
How to write a query with a full outer join in ms sql server?
What is the difference between stored procedure and functions?
What is user-defined scalar function?
What are the database objects? : SQL Server Architecture
Explain about sql server login?
What do you understand by mirroring and mention the advantages of the mirroring?
What is NOT NULL Constraint in sql server 2012?
Explain raiserror in sql server?
How to how to convert numeric expression data types using the convert() function??
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is the filtered index?
What are security principals used in sql server 2005?
