Answer Posted / kala suresh

--BY USING A TEMP TABLE TO DELETE DUPLICATE ROWS OF A TABLE
WITH OUT A PRIMARY KEY COLUMN OR AN IDENTITY COLUMN

SELECT Name, age, ROW_NUMBER() OVER(ORDER BY age) AS
'RowNumber' into #temp1 FROM RowNumber

delete from #temp1 where rownumber not in(select
max(rownumber) from #temp1 group by name,age)

delete from rownumber

select * from #temp1 into rownumber

drop table #temp1


--BY USING AN IDENTITY COLUMN TO DELETE DUPLICATE ROWS OF A
--TABLE WITH OUT A PRIMARY KEY COLUMN

delete from rownumber where id not in(select min(id) from
rownumber group by name,age)
select * from rownumber

Where in ms sql server is ’100’ equal to ‘0’?

594

---

what is a transaction and what are acid properties? : Sql server database administration

522

---

What is temporary stored procedure?

546

---

What is dynamic cursor in SQL SERVER?

559

---

What are policy management terms?

556

---

---

can we have a nested transaction? : Sql server database administration

494

---

What is user defined stored procedures?

559

---

How to use subqueries with the in operators in ms sql server?

558

---

How to execute the cursor queries with "open" statements?

611

---

Define ACID properties in a Database?

622

---

Does index speed up select statements?

581

---

Explain the different types of joins?

564

---

What is repeatable read?

540

---

System variable and temporary variables

1704

---

What is t-sql script to take database offline – take database online.

600

---