Answer Posted / shankar

First Of All Create Table
create table EMP(empid int, ename varchar(10),sal int,
deptid int)

insert into EMP values(11, 'Ram', 10000, 10)
insert into EMP values(11, 'Ram',10000,10)
insert into EMP values(22, 'Raj', 20000, 20)
insert into EMP values(22, 'Raj', 20000, 20)
insert into EMP values(33, 'Anil', 15000, 30)
insert into EMP values(33, 'Anil', 15000, 30)
insert into EMP values(44,'bbb',11111,40)
--Now Run This query It works
Declare @empID int, @RecCount int,@Name varchar (10),@Sal
int, @deptid int
SET @RecCount = 0
Declare MyCur Cursor for
Select empid,ename Sal,DeptID,Count(ID)-1 as Records from
EMP Group BY empid,ename Sal,DeptID having Count(empid)>1
Open MyCur
Fetch FROM MyCur INTO @empID,@Name,@sal,@DeptID,@RecCount

WHILE @@FETCH_STATUS = 0
BEGIN
SET ROWCOUNT @RecCount

DELETE from EMP where empID= @empID
SET @empID= 0
SET @Name = ''
SET @Sal= 0
SET @DeptID = 0
SET @RecCount = 0
SET ROWCOUNT 0
Fetch FROM MyCur INTO @empID,@Name,@sal,@DeptID,@RecCount
END

Close MyCur
DEallocate MyCur

What are the different types of upgrades that can be performed in sql server?

1114

---

Explain aggregate functions?

1026

---

How can you find out how many rows returned in a cursor?

969

---

What is an inner join?

914

---

How to optimize stored procedures in sql server?

1121

---

What is the difference between a check constraint and a rule?

1130

---

Do you think BCNF is better than 2NF & 3NF? Why?

1226

---

What is acid properties?

1018

---

explain different types of joins? : Sql server database administration

920

---

What is the importance of a recovery model?

1000

---

Explain nested trigger in sql?

1005

---

What are the difference between primary key and unique key? : sql server database administration

891

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

960

---

What do you know about normalization and de- normalization?

869

---

Explain log shipping and mention its advantages.

988

---