Answer Posted / mohan

create table #temp(empid int, ename varchar(10),sal int,
deptid int)

insert into #temp values(11, 'Ram', 10000, 10)
insert into #temp values(11, 'Ram',10000,10)
insert into #temp values(22, 'Raj', 20000, 20)
insert into #temp values(22, 'Raj', 20000, 20)
insert into #temp values(33, 'Anil', 15000, 30)
insert into #temp values(33, 'Anil', 15000, 30)
insert into #temp values(44,'bbb',11111,40)

select * from #temp

set rowcount 1
delete from #temp where empid in(select empid from #temp
group by empid having count(*)>1)
while @@rowcount>0
begin

delete from #temp where empid in(select empid from #temp
group by empid having count(*)>1)
end
set rowcount 0

select * from #temp

Define cursor locking

1061

---

Do you know what is fill factor and pad index?

1047

---

What are the advantages of log shipping?

1039

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1115

---

Can we perform backup restore operation on tempdb?

1075

---

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

1105

---

What is raid and what are different types of raid levels?

1194

---

What are the components of dbms?

997

---

what are cursors? : Sql server database administration

1105

---

Explain primary key in sql server?

1074

---

How to transfer a table from one schema to another?

1046

---

What triggers long term care?

1088

---

Is a primary key unique?

1036

---

Can you roll back the ddl statement in a trigger?

1021

---

How to create dbo table in sql server?

1006

---