Stored procedure using scope identity in microsoft sql server

//////////

Create

/////////

create table Salary (Serialno int identity (1,1),id int,name varchar(20),salary money)

select * from Salary

//////////

insert

/////////

create procedure ms_salaryinsert(@id int,@name varchar(20),@salary money)

as begin 

insert into salary (id, name, salary) values (@id,@name,@salary)

select Scope_identity()

end

//////////

Update

/////////

create procedure ms_salaryUpdate(@id int,@name varchar(20),@salary money)

as begin 

update Salary set name=@name,@salary=@salary where id=@id

end

//////////

Select

/////////

create procedure ms_salarySelect

as begin 

select * from salary

end

//////////

Delete

/////////

create procedure ms_salaryDelete(@id int)

as begin 

delete from Salary  where id=@id

end

//////////

Exec

/////////

exec ms_salarySelect

exec ms_salaryinsert 1,'Sreenivasulu g',2000

exec ms_salaryUpdate 1,'Raheem',35000

exec ms_salarydelete 1