How to swap the data of two columns in a table. both the
columns containing varchar values.
Answer Posted / san
create table san(empid int,empname varchar(10))
insert into san values(1'san')
update san set empid=empname,empname=empid
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is dbcc command in sql server?
What are commonly used mssql functions in php?
What is sql server transaction log file?
What is data compression? : sql server database administration
How to backup encryption key ?
How do I view a trc file?
Write a program to fetch first 10 records from a file?
Please differentiate between a local and a global temporary table?
What is the primary use of the model database?
What is shrink log file?
Where are sql server user names and passwords stored in sql server?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is a database in ms sql server?
What is a trace frag? Where do we use it?
What is difference between index seek vs. Index scan?