HI,

try this then exec the sp with null

CREATE proc Example

(

@empid int,

@Mode varchar (1),

@fname varchar (100)= null,

@lname varchar(100)=null

)

As

begin

-- CREATE TABLE [emp] (

-- [empid] [int] IDENTITY (1, 1) NOT NULL ,

-- [Fname] [varchar] (100) NOT NULL ,

-- [Lname] [varchar] (100) NOT NULL

-- ) ON [PRIMARY]

-- GO

If (@Mode='S')

Begin

Select fname,lname from emp where empid = @empid

End

If (@Mode='I')

Begin

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

End

If (@Mode='U')

Begin

Update emp set fname=@fname,lname=@lname where empid =@empid

End

end

go