What is fixed-length & variable-length characters? Tell me their differences??

Answer:

In Sql Server there are two types of character data types. They are

1.fixed-length (i.e char)
2.variable-length (i.e varchar)

The main differences are maximum length and in whether trailing spaces are retained