Implicit converts for inserts

• alex.palmer

  SSCrazy

  Points: 2292

  More actions

  August 25, 2017 at 2:02 am

  #332308

  Hi

  do implicit converts in insert statements matter? I talking about converting between char and varchar and differing lengths

  I know in Selects they can cause scans instead of seeks, but I can't see any impact for inserts from my limited testing

  Is there anything I should know?

  Cheers

  Alex

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 25, 2017 at 4:33 am

  #1956773

  The only place where implicit conversions can cause scans is when they happen in the JOIN or WHERE clause of a statement (any statement)

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass