This is one those queries that just makes me want to shake my head; as you are searching for COLUMN_NAME which you already know.
The 2 choices for the result of this query are either going to be NULL
or the name of the column name you are searching for
WHERE TABLE_NAME = N'EmpDatas'
AND COLUMN_NAME = N'JobTitle'
It just does not make sense to me when compare to the C# call which looks like a search of the
table for an employee who has a job title containing the text contained in parameter
var search = db.EmpDatas.Where(p => p.JobTitle.Contains(parameter));
What I would think think you actually want for a query is
WHERE JobTitle LIKE '%parameter%'