--PRINT TOTAL SALARY using CURSOR
CREATE TABLE Employee
(
EmpID int PRIMARY KEY,
EmpName varchar (50) NOT NULL,
Salary int NOT NULL,
Address varchar (200) NOT NULL,
)
GO
INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(1,'Mohan',12000,'Noida')
INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(2,'Pavan',25000,'Delhi')
INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(3,'Amit',22000,'Dehradun')
INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(4,'Sonu',22000,'Noida')
INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(5,'Deepak',28000,'Gurgaon')
GO
SELECT * FROM Employee
------------------CURSOR-------------------
alter proc usp_emp_totalsal as
begin
set nocount on
declare @id int
declare @name varchar(50)
declare @Each_row_sal int=0
declare cursortable cursor
for select empID,empname,salary from Employee
open cursortable
fetch next from cursortable into @id,@name,@Each_row_sal
declare @totalsal int=0
while(@@FETCH_STATUS=0)
begin
print @totalsal
set @totalsal=@totalsal+@Each_row_sal
fetch next from cursortable into @id,@name,@Each_row_sal
end
close cursortable
deallocate cursortable
print @totalsal
set nocount off
end
exec usp_emp_totalsal