I'm having a problem specifying a value within an
OPTIMIZE FOR statement. I'd like to optimize the query with the value as a string, but I must be doing something wrong, because SQL gives the following error:
The value specified for the variable "@test" in the OPTIMIZE FOR clause could not be implicitly converted to that variable's type.
The example below is slightly contrived but the problem is the same as the one I'm having with my actual query.
declare @TEMP table(asWord nvarchar(max), asNumber int) insert into @TEMP (asWord, asNumber) values ( 'one', 1 ), ( 'two', 2 ) DECLARE @test nvarchar(max) SET @test = 'one' select * from @TEMP where asWord = @test OPTION (OPTIMIZE FOR(@test = 'one'))
What am I doing wrong?