GetStudents (Stored Procedure)

CREATE PROCEDURE [dbo].[GetStudents]

    @Name varchar(50) = ''

AS

BEGIN

IF(TRIM(@Name) != '')

BEGIN

select * from Students where Name like @Name +'%'

END

ELSE

BEGIN

select * from Students

END

END