Answer Posted / mahesh babu ummaneni

inthis we have some steps
-->first rimove duplicate values from table
select distinct * from ta1
-->copy the data into anothetable
select distnice * into tb2 from tb1
-->remove the first table
drop table tb1
-->copy the tb2 data into tb1
select distinct * into tb2 from tb1

What are data files?

984

---

How do you delete duplicate rows in sql server?

901

---

Please differentiate between a local and a global temporary table?

951

---

explain the storage models of olap? : Sql server database administration

889

---

Can sql servers linked to other servers like oracle?

904

---

Explain about the command-line tool SQLCMD?

1019

---

Tell me what is difference between view and materialized view?

887

---

What is log cache in sql server?

984

---

How to check if stored procedure is running in sql server?

962

---

Is BCNF better than 2NF & 3NF? Why?

1002

---

Can we write trigger for view?

954

---

How do you create a data source?

869

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

---

How to how to convert numeric expression data types using the convert() function??

990

---

What are the requirements on sql server network connections?

898

---