Alter with store procedure.

 Alter with store procedure.

Create procedure SpGetEmployeeByIdAndName
@Id int,
@name varchar(50)
as
begin
Select * from Test_EmployeeTbl where Id = @Id and Name = @name
end

I change the *  from name, Salary of employe 👇

Alter procedure SpGetEmployeeByIdAndName
@Id int,
@name varchar(50)
as
begin
Select Name,Salary from Test_EmployeeTbl where Id = @Id and Name = @name
end

 

Show the name and salary of employee 

SpGetEmployeeByIdAndName  1, 'Rahul'

 

 Seeing the text of SP. SP_helptext. Next page 👉 Click here