Question: what is the difference between varchar and text in sql server?
Answer: The basic difference is that a TEXT type will always store the data in a blob whereas the VARCHAR(MAX) type will attempt to store the data directly in the row unless it exceeds the 8k limitation and at that point it stores it in a blob. The text datatype is deprecated and should not be used for new development work.