SQL Server collation setting

Hi everybody. Could you please describe, why when i change collation setting of database from case sensetive to case insensetive it has influence on both data and SQL code. May be there is some fe...