Answer Posted / sandeep rana

create table tmp_t
(
aa varchar2(50),
bb varchar2(50)
)


--insert into tmp_t values('1','5')


select * from tmp_t

update tmp_t set aa=bb , bb=aa

How to delete duplicate rows from table except one?

931

---

Is truncate autocommit?

897

---

Difference between Logical Page and Physical Page in SSRS.

459

---

What is a filestream?

942

---

Why is normalisation important?

899

---

How to fine-tune reports?

247

---

Explain indexed views and partitioned view with their syntax.

1077

---

List the data types available in mssql?

957

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

911

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

969

---

What is exporting and importing utility?

1017

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1025

---

how to use DTS package in 2000,2005,2008 in sql server

1786

---

Is resultset an interface?

903

---

What is tcl in sql server?

1076

---