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.
Difference Between Sql Server VARCHAR and VARCHAR(MAX) Data Type. Ideally, it is better to compare Text and Varchar(MAX) data types, as in Sql Server 2005 Varchar(MAX) data type was introduced as an alternate for Text data type. Varchar(Max) data type provides multiple advantages over Text data type. Like many initially when Varchar(MAX) datatype was introduced in Sql Server 2005, I too was not clear about the difference between Varchar and Varchar(Max) and which one to use when. Hope the differences listed in the below table clarifies these queries.