ALTER PROCEDURE [dbo].[SP_Details1]
@empID varchar(50)
AS
BEGIN
Declare @records varchar(max)
IF ISNULL(@EmpId,0)!=0
IF EXISTS (
set @records='empid doesnot exist'
)
BEGIN
select @records= [Num] from [Employee] where [Num]= @empID
select @records as [EmpID]
END
END