Column 'Name' in table 'Students' is of type 'Text'.
Given the query chose the correct 'Where' statement. The query should return all the students with the exactly given name.

declare @name nvarchar(100)
set @name = 'Joe Doe'
select * from students

The data types 'Text' and 'Nvarchar' are incompatible in the equal to operator.
where name like '%' + @name + '%' is a wildcard search.