Home Forums SQL Server 2008 SQL Server 2008 Administration Whydoes 'N before the WHERE value causes an Index SCAN RE: Whydoes 'N before the WHERE value causes an Index SCAN
Lynn Pettis
SSC Guru
Points: 442467
More actions
November 30, 2012 at 7:24 am
#1564356
The following link should help you understand data type precedence better:
http://msdn.microsoft.com/en-us/library/ms190309(v=sql.100).aspx