I want to list all student details from the student table, but there is a parameter @Name where we have to pass the name of the student. But i want all students , what i have to pass as the parameter to list all students? , here i cant change the stored procedure..
create proc ListStudents @Name varchar(20)
as
begin
select * from StudentDet where Name=@Name
end