Discussion in 'SQL Server 2005 General Developer Questions' started by roshriya, Aug 20, 2008.
What is collation in sql 2005?
the sorting order in which sql server allocates the data
examples: case -sensitive
if you give case sensitive as the allocation then you have to type the letters exactly how you have given.
for case insensitive you can type capital letters as well as small letters.
Please refer Books Online about the collations where you can find all the information you wants to know
Separate names with a comma.