title: Why do I get CONVERT_IMPLICIT for same data type?
body: <p>Consider this snippet:</p>
  
  <pre><code>CREATE TABLE #Temp ( Name varchar(100) )
  GO
  
  DECLARE @Name varchar(100)
  SELECT  @Name = '123'
  
  SELECT * FROM #Temp WHERE Name = @Name
  </code></pre>
  
  <p>When inspecting it's execution plan, I got a <code>CONVERT_IMPLICIT</code> call on <code>@Name</code> variable:</p>
  
  <pre><code>[tempdb].[dbo].[#Temp].[Name]=CONVERT_IMPLICIT(varchar(100),[@Name],0)
  </code></pre>
  
  <p>Why this happens, as I have same data types?</p>