How to get row having empty rows in SQL Server

Vasanth057 says:

I have a table like 

Student1 stud1mark Student2 Stud2mark student3 stid3mark.

THis are all the column name .

 

If the user enter Student1 name it returns Stud1mark 

or Student2 name means stud2Mark

or Student3 name means Stud3Mark..

 

How to do this ??

Why you created such Database structure where student name store in three different column and student marks stores in three different column? Instead of making confusing Database structure of database you can just add two column names as Student and StudentMarks Where student column will contain student name and in StudentMarks will contains student marks. And in simple select query you can match the student name in where condition to get proper details.