Seeing the text of SP. SP_helptext

 Seeing the text of SP. SP_helptext

 
Syntax: 👉   Sp_helptext      ProcedureName 

Query 👉    Sp_helptext   SpGetEmployeeByIdAndName

 

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