Interested to Buy Any Domain ? << Click Here >> for more details...
How to swap the data of two columns in a table. both the
columns containing varchar values.
- 9 Answers
- 17823 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
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Do you know exporting and importing utility?
What is the contrast amongst drop and truncate?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Do you know what is difference between stored procedure and user defined function?
What is primary key and example?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the approximate numeric data types?
What are the difference between clustered and a non-clustered index?
How to change the system date and time from SQL Plus Terminal ?
How to return the date part only from a sql server datetime datatype?
What is the recovery model? List the types of recovery model available in sql server?
What is set nocount on?
What causes index fragmentation?
what is the information that can be stored inside a bit column? : Sql server database administration
