Hi,

In your table shows all col are not null,

Then in the sp line

If (@Mode='I'

Begin

Insert into emp(fname,lname) values(@fname,@lname)

End

returns with error

AND what error you need to return,

Because it’s automatically return by not null column

ARUN SAS