My Rational Rights

Create procedure dbo.SearchEmployee ( @Employeename varchar(20), @EmployeeDesig varchar(20), @EmployeeLocation varchar(20), @EmployeeInterest varchar(20) ) as begin set nocount on set @EmployeeName = '%' + @EmployeeName + '%' set @EmployeeDesig = '%' + @EmployeeDesig + '%' set @EmployeeLocation = '%' + @EmployeeLocation + '%' set @EmployeeInterest = '%' + @EmployeeInterest + '%' SELECT EmployeeName from EmployeeMaster (nolock) WHERE (nullif(@EmployeeName, '') is null or EmployeeName like @EmployeeName) and (nullif(@EmployeeDesig, '') is null or EmployeeDesignation like @EmployeeDesig) and (nullif(@EmployeeLocation, '') is null or EmployeeLocation like @EmployeeLocation) and (nullif(@EmployeeInterest, '') is null or EmployeeInterest like @EmployeeInterest) set nocount off end go seaching on name and interests exec SearchEmployee 'shriram', null, null, 'SQL' searching on intere...

Create Proc Sp_helpDate @mark1 int=10,@mark2 int=10,@mark3 int=10,@mark4 int=10 AS BEGIN SELECT @mark1+@mark2+@mark3+@mark4 END EXEC Sp_helpDate @mark3=70