1. Write a program that stores 10 user names. When the user re-enters his name the program should display the message “Already Exists”.

CREATE PROCEDURE spempcheck
(
    @empid varchar(50),
    @status char(1) output 
)
Begin
    declare @cnt int
    declare @errmsg varchar(1000)
    
    select @cnt=count(*) from Emp where Emp_id=@Empcode
    if(@cnt>0)
       begin
          set @status='T'
       end
    else
       begin
          set @status='F'
       end
End