procedure with only two parameters, one for id (it could be student, teacher or group id), we will call it @id and other to hold information that will decide that what type of id is being passed to stored procedure i.e. student, teacher or group, we will call it @idTypeDECLARE @Id INT -- It could be StudentId,TeacherId,GroupIdDECLARE @IdType VARCHAR(10) -- Type could be Student,Teacher or GroupWe