Create PROCEDURE [dbo].[UpdateRecord]
(
   @empId int,
   @name varchar(200),
)

AS

DECLARE @chkName varchar(200)

SET @chkName=(SELECT TOP 1 Emp_Name FROM Employee WHERE EmpId=@empId )

IF @chkName IS NULL

BEGIN
   UPDATE Employee SET Emp_Name = @name WHERE EmpId = @empId
END