adspace


What is sql collation?

Answer Posted / Saurabh Singh Chauhan

SQL Collation is a set of rules that determines how SQL Server compares and sorts data. It includes the sorting order for characters, as well as the rules for case sensitivity, accent sensitivity, and other factors. Collations are used to ensure compatibility between different databases or even different languages.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the properties of the transaction?

1072


What are the source of constraints?

1009


Can we do dml on views?

1038


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1071


Does view occupy space?

1019


Why use identity in sql server?

1199


What is self contained sub query?

1140


How do I find the sql server version?

1102


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1213


What is a scheduled job or what is a scheduled task?

1039


Disadvantages of the indexes?

1223


What is the difference between for xml raw and for xml auto?

1117


What are wait types?

1249


How can you append an identity column to a temporary table?

1070


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8230