Hi , I have this stored procedure , I want to select empid, empname is possible to without change stored procedure.
create procedure sp_employee
as
begin
SELECT empid, empname, empdestination, empemail, empmobile
FROM employee
end
select empid,empname,empmobile exec sp_employee
is it correct?