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

67.

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

where name = @name

where cast(name as nvarchar(1000)) = @name

where name like '%' + @name + '%'

View Description

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