A collateral contract is one where the parties to one contract enter into or promise to enter into another contract. Thus, the two contracts are connected and it maybe enforced even though it forms no constructive part of the original contract.or example, a collateral contract is formed when one party pays the other party a certain sum for entry into another contract. A collateral contract may be between one of the parties and a third party.
Using Large-Value Data Types. The max specifier expands the storage capabilities of the varchar, nvarchar, and varbinary data types. varchar(max), nvarchar(max), and varbinary(max) are collectively called large-value data types. You can use the large-value data types to store up to 2^31-1 bytes of data.
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. For example, CHAR(30) can hold up to 30 characters. The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value from 0 to 255.