The procedure itself is quite straightforward, modify the statement as per requirements and then include inside a procedure, see
CREATE PROCEDURE [
^]
About the query, I would advice to separate the first column to two separate columns if the data describes different things. Concatenated columns should never be stored inside the database.
If the columns would be separate, then your query to fetch the row could be something like:
INSERT INTO Marks (strName, anotherfield, marks)
SELECT stdName, anotherField, marks
FROM (
select 'std' as stdName, 1 as AnotherField, 98 AS Marks
union all select 'std' as stdName, 2 as AnotherField, 96 AS Marks
union all select 'std' as stdName, 3 as AnotherField, 95 AS Marks
union all select 'std' as stdName, 4 as AnotherField, 97 AS Marks
union all select 'std' as stdName, 5 as AnotherField, 93 AS Marks) AS sub
WHERE sub.AnotherField = @procedureParameter