Sql server

Question

what is the use of collate keyword in sql server? and where should we use that keyword  i mean at what situation we use that keyword?

santosh ghundre · Answer

thanx ravi

Ravi Patel · Answer

Hi Santosh  check this http://www.dotnetfunda.com/forums/show/3599/what-is-the-use-of-collate-in-sql-server http://stackoverflow.com/questions/5039211/what-does-collate-sql-latin1-general-cp1-ci-as-do

Upendra Pratap Shahi · Answer

http://www.dotnetfunda.com/forums/show/3599/what-is-the-use-of-collate-in-sql-server http://sqlwithmanoj.com/tag/collate-database_default/

Raja T · Answer

HI Checkout bellow urls https://www.mssqltips.com/sqlservertip/3215/how-column-collation-can-affect-sql-server-query-performance/ http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/