varchar(500) vs varchar(max)在sql server中的区别。

I want to know what are pros and cons while using varchar(500) vs varchar(max) in terms of performance, memory and anything else to consider?I want to know what are pros and cons while usi